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 response.

 

So here's my visualisation:

 

And this is the measure I'm using:

 

Here's the visualisation with my overlaid treemap (which I've made smaller so you can see how it's just opaque white). Based on the measure it should be transparent now, since a slicer value is selected, but it remains solid white.

I know it's a problem with the transparency, as if I change the measure to show blue when a slicer value is selected, the treemap does indeed turn blue when I use the slicer.

 

Any ideas what I'm doing wrong?

 

Thanks very much.

Pragati11's avatar
Pragati11
Super User
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
  • 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
      Super 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: