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 ,

 

I mentioned in my previous response that I am using a measure on my matrix and I am able to apply visual level filter.

Are you saying against Filter Selected measure, you are not able to chnage selection using dropdown as shown below:

 

You need to select is option from dropdown. --> Then write "1" in the next box  --> Then APPLY

 

If this doesn't work, try following:

Filter Selected measure is based on your CUSTOMER NAME column.

I suggest moving CUSTOMER NAME and COUNT measure to your matrix visual.

Then try applying Filter Selected as a visual level filter to your matrix. This should work.

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Pragati11 ,
Thank you very much for your inputs. Your given solution solved my problem. I appreciate your help. 

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

    HI Anonymous ,

     

    If the solution helped and solved your issue, don't forget to mark my response as a solution.

    This may just help someone else in the future on the forum. 🙂