Empty report when when no slicers are checked

[Anonymous]

Hi,

Can you make an report empty when no slicers are checked?

Now when my slicers are unchecked it show weird data in my visuals.

kind regards,

Davina

[Anonymous]

Hi @Anonymous ,

You could refer this blog.

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/ 

Best Regards,

Jay

[amitchandak]

@Anonymous , I doubt there something for the page . You can make a visual blank based on if filter values are selected on not.

You can use isfiltered

refer this example: https://www.kasperonbi.com/show-values-in-a-chart-only-when-a-slicer-is-selected/

Bookmark is another way , but there one button can show hide - I doubt slicer value can.

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

[Greg_Deckler]

@Anonymous - Possibly if you write measures like:

Measure = IF(ISFILTERED('Slicer'[Column]),<calc>,BLANK())

Maybe a button/bookmark so they choose something in the slicer, hit a button and it unhides visuals. That's a weird UX though.