Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Showing visual only when slicer selected

Hi everyone,   I have a visual that I want to display data only when the user selects a category from a slicer. If nothing is selected from the slicer, I just want a blank space. I found this post,...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Anonymous ,

     

    I tried the following measure for transparency at my end without SWITCH statement and it works for me:

    Make Transparent =
    IF(
    ISFILTERED(ClothingSales[Category]),
    "#FFFFFF00",
    "#FFFFFF"
    )
     
    Try this and see if it works.
     
    Also, in your measure, you are missing "#" from 2nd condition. You are just using "FFFFFF". It should be "#FFFFFF'.
     
    Thanks,
    Pragati
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Anonymous ,

     

    I wrote a blog sometime back on similar functionality. Can you check once if you are following all these similar steps:

    https://community.powerbi.com/t5/Community-Blog/Display-Custom-Message-in-the-Visual-Until-a-Selection-is-Made/ba-p/1438721

     

    If still it doesn't work, then share your pbix file by removing any sensitive information from it.

     

    Also I am wondering; if this was not working then why was the solution accepted. 🙂

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
2 years ago

HI Anonymous ,

Can you please share some screenshots here around what you are trying to do?

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hey Pragati11 , 
Thanks for addressing the concern but can't share the screenshot. You can create simple measure>put it in table> and try to apply Filter Selected on Visual level filter on that Table Visual. It won't work, may I know why?