Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello! I'd like to filter a dashboard based on the source table that the data is coming from. Consider an example where I have four different tables (Contact Info, Demographic Info, Event Info, and Financial Info). If my dashboard has a couple visualizations using variables from "Contact Info," a couple visualizations using variables from "Demographic Info," etc, I'd like to filter the view to see "Contact Info" visualizations only, for example.
I also have a fifth table, "List of Tables," that lists the names of the four data tables, if that's helpful. I'm open to using some sort of slicer to filter or bookmarks to toggle between views. I know I can manually sort the visualizations into bookmarks, but I'm hoping for a way to filter that would allow for additional tables to be added so that I wouldn't have to manually sort them into bookmarks.
Ideally, I'd have some sort of slicer on my dashboard that allows the user to filter by source table.
Thanks in advance!
Solved! Go to Solution.
Have you tried using a field parameter? This would allow you to have a generic set of visualizations, and toggle the desired source table to display. You can create a field parameter with either columns or measures.
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Proud to be a Super User!
Have you tried using a field parameter? This would allow you to have a generic set of visualizations, and toggle the desired source table to display. You can create a field parameter with either columns or measures.
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Proud to be a Super User!
This is great, thank you!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |