Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello everyone,
Thank you in advance for your help. I've an idea althought I dont know if it is possible.
We have a sharepoint list similar to this one in which each assigned analyst have to attach an excel document in astandarized manner in each row. Every row contains only 1 excel file and all of them have the same structure (Number of columns, names of the columns, etc).
Now I was able to Merge the files by using this helpful guide, but the problem is that I need to filter my sharepoint data BEFORE merging the files and by using this method it wont give me the option.
IE: Filter the data by "Argentina" Only and THEN merge all of the excel files.
Is there any workaround for this?
THANK YOU!!!
Filtering after merging is a relatively simple method. You can apply the filter directly to the corresponding column after merging, or create a parameter to filter items.
User | Count |
---|---|
61 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
83 | |
62 | |
45 | |
40 | |
39 |