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.
I have a filter control, it lists values as would be expected.
It has Show "Select All" option = Off
Single Select option = On
The issue is that if someone clicks on the filter and clears the selection it selects all the values (or removes the filter).
Is there anyway to REQUIRE a selection on the filter?
If nothing is selected then I don't want any data to be returned.
Basically, without a selection I want it to select "none" as opposed to "all".
If you clear the selection the drop down even says "All" even though Select All is off.
Thank you, and yes that would be the desired behavior.
However, to make that work I would have to make new measures for every single column of data I want to display.
I already have data models with hundreds of measures (or just columns used as attributes).
Is there no way to set a filter to behave like a prompt where nothing happens until you provide a selection?
Your requirement seems to be something like "the slicer should not return results when nothing is selected".
Currently, it doesn't support in Power BI desktop.
you can vote a similar thread here.
Best Regards
Maggie
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |