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.
Hello, I'm new to PowerBI and wasn't quite sure what to look for when looking for a solution to this problem. So feel free to point me in the right direction in case this question has already been answered before.
Lets take some sample data to illustrate my question:
Product | Category |
1 | Cat.A |
2 | Cat.A |
3 | Cat.A |
4 | Cat.B |
5 | Cat.B |
6 | Cat.B |
Given this, I want to have two slicers at the top of my dashboard. One to select whether a user wishes to filter on specific products or categories. And the second one to actually make the selection. The items in the second slicer should change based on the selection made in the first slicer.
Thank you!
Hello @SSchepers ,
In my test, you need to create two other tables for slicers, then use the following formula:
Measure =
SWITCH (
SELECTEDVALUE ( 'Slicer options'[Wish to filter?] ),
"Yes", IF ( MAX ( 'Table'[Product] ) IN ALLSELECTED ( 'forSlicer'[Product] ), 1 ),
"No", 1
)
After applying the measurement to the filter panel (set "is 1"), My display looks like this:
Have I answered your question? Please mark my answer as a solution. Thanks a lot.
If not, load some insensitive data samples and expected output.
Best regards
Eyelyn Qin
@Anonymous , there can be few ways to get that. See bookmark and button can help
https://www.youtube.com/watch?v=z9jdkyyE3WU
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |