Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, is there any way to load different data on powerBI visuals like tables based on filtering? For example, I have 5 xlsx files that I upload on powerBI, the columns are the same, only thing that changes is the source table of the visualization, I want to have a slicer with index values like 1,2,3,4,5, when 1 is selected the data from the excel1.xlsx file should be loaded into the visualization, when 2 is selected the excel2.xlsx should be loaded.
Is there anyway to do that?
Solved! Go to Solution.
Hi @georgepaph12, my suggestion to you would be to add a column to each table (either in PQ or directly in Excel) with the index of each file and append them in Power Query. After that, use the Index Column as a filter (slicer) in your visual and the data will "change" between files. Additionally, you can force a single selection on the slicer so that it always has a values selected.
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
Hi @georgepaph12, my suggestion to you would be to add a column to each table (either in PQ or directly in Excel) with the index of each file and append them in Power Query. After that, use the Index Column as a filter (slicer) in your visual and the data will "change" between files. Additionally, you can force a single selection on the slicer so that it always has a values selected.
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |