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.
The default functionality for a slicer in Power BI seems to be that if nothing is selected in a slicer then all records are shown in visualisations on the same report where the interactions are set as filter. What I would like to be able to do is not show anything in these other visualisations until one or more entries are selected in the slicer. Is this possible?
Solved! Go to Solution.
Hi @Dave0145,
For your requirement, you can create a measure like this:
SlicerCheck = =if(calculate(distinctcount([SlicerColumn]),allsel
Then place this measure in a table visual, set filter condition as is Y. If you want to select multiple values in a slicer, set is N.
For more information, see:
visual filter problem--unpredictable behavior
Best Regards,
Qiuyun Yu
The Curbal video at https://www.youtube.com/watch?v=gYbGNeYD4OY&t=52s, starting at about 04:15, shows how to create a blank in a visualization until a slicer value is selected.
Further explanation:
- if nothing selected in slicer, show no data items in associated visualisation
- if one or more items selected in slicer, show data for those in associated visualisation (as per current slicer functionality
- if Select All chosen in slicer, show data for all items in associated visualisation
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |