Forum Discussion
Anonymous
6 years agoNot applicable
Hide and Show based on Slicer selection
Hi All, Based on slicer selection my card should get hid and show. In below eg. If i select ID = 1 then my card will display "Yes" in the status and card should be visible. If i select ID = 2 the...
avatorl
Impactful Individual
6 years agoThere is no easy way to show/hide visuals depends on slicer selection. What you can do:
1) vote for an idea https://ideas.powerbi.com/forums/265200-power-bi-ideas?query=slicer%20hide%20visual
2) if your list of slicer values is short and predifined (like your 1, 2 and 3 options) then use buttons and bookmarks instead of slicer.
3) you can hide card data and category caption using conditional formatting and making font color same as backgroud color. Probably you'll be able to hide table as well using contitonal formatting and maybe measures that return BLANK() depends on slicer selection. This is just a workaround.