Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Blank visuals by default

Hi everyone 🙂 I have a sliser with three values, one of them being (Blank). How do I make the Blank default choice so when an end-user opens the report, he sees all visuals empty until he choses eit...
Need Help
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

Try a dax as follows:

IsBlankCheck = IF(ISFILTERED(CD[name]), 1, 0)

 

Move this to your visual on your page in visual level filter with "1" selected. So, when you select a slicer value in CD[name], the visual will display result, otherwise it will show blank visual.

 

Thanks,

Pragati

 
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Pragati11 I applied the filter (Show items when the valus is 1). But it is still shows all three slicers. 

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

    Is it possible to share your pbix file? You can share it as a private message if you can't share the .pbix file here.

     

    Thanks,

    Pragati