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.
Hi ,
I am using
Solved! Go to Solution.
Hi, @Anonymous
This is the expected behavior if you are using the default slicer in Powerbi Desktop.
Based on my test,when the slicer ‘select all’ is checked, it is actually equivalent to ‘nothing is selected’. This is by design, it just makes the slice appear to be in an all-selected state.
Therefore, when you use isfiltered to force the visual to show blank values when ‘nothing is selected’, the visual also show blank values when 'all selected' is checked.
As a workaround, you can try to use Hierarchical filter.
Best Regards,
Community Support Team _ Eason
Hi, @Anonymous
This is the expected behavior if you are using the default slicer in Powerbi Desktop.
Based on my test,when the slicer ‘select all’ is checked, it is actually equivalent to ‘nothing is selected’. This is by design, it just makes the slice appear to be in an all-selected state.
Therefore, when you use isfiltered to force the visual to show blank values when ‘nothing is selected’, the visual also show blank values when 'all selected' is checked.
As a workaround, you can try to use Hierarchical filter.
Best Regards,
Community Support Team _ Eason
Hi @Anonymous
Try this
Measure = CALCULATE( IF( ISBLANK(SELECTEDVALUE('TERM'[TermName])) && DISTINCTCOUNT('TERM'[TermName]) = COUNTROWS(ALL('TERM')),0,1), ALLSELECTED( CUSTOMERTABLE))
Regards
Phil
Proud to be a Super User!
Hi Phil,
Thank you for your reply. This solution does not show a blank visual when there is nothing filtered. Could you help with troubleshooting
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 |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |