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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Pragati11 

 

Thanks for your reply and sorry for the delay in responding. It still doesn't work for me -- I had initially tried using the IF statement and it hadn't worked, so I tried using the switch function instead.

 

This is what I see:

I know the problem lies in the transparency because it works when I change the colour. So for example, if I set it to turn blue when the slicer is selected but otherwise remain white, it works:

Any ideas why it's not working for transparency?

 

Thanks in advance!

 

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

Hi Anonymous ,

 

Your DAX is different to what I suggested. Can you use exact DAX and try:

Make Transparent =
IF(
ISFILTERED(ClothingSales[Category]),
"#FFFFFF00",
"#FFFFFF"
)
 
Thanks,
Pragati
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Pragati11 ,

     

    It doesn't make a difference:

     

    • Pragati11's avatar
      Pragati11
      Icon for Super User rankSuper User
      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks Pragati11 ,

         

        The solution in your blog post works perfectly and was exactly what I was after. I'd initially tried something similar, but hadn't managed to get it working! So thank you for that, it's super helpful. 

         

        Someone else had accepted your previous solution, not me! 🙂

         

        Thanks again 🙂