Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Does anyone know if there is a way, with code or what have you, that will make a slicer a dropdown list (like a cascading dropdown list in excel)? Or have a small search box within the slicer for lists that are long that way a user doesn't have to scroll to find what they want to click on?
I have suggested this as an Idea. Feel free to vote for it 🙂
Just did!! It got 3 of my votes!
Nice, thank you
Hello @Be
According to what I've understood you would like to get cascading slicer, just like in Excel (selecting one will filter the other slicers)?
If it ok, this is a workaround while waiting for the eventuality of having a real one :
If you put slicers with columns belonging to the same table (assuming for example you have your dimension labelled in your fact table), the cascading is automatic 🙂
My example, display two slicer from columns belonging to the same table : slicer 1 display type of posts and slicer 2 display location of posts.
When I choose a type the location change to show the relevant data :
And if I choose a location slicer value, the type value is updated too :
But remember that the slicer should
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |