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
2 years ago

Hi Pragati11 
I have the same problem, But my Matrix Visual is made up of all measures I created. So i can not pull "Filter Selected" measure to my table visual's visual-level filter section. The filter does not give me the optipon to drop down and select "1" or "2". What should I do?   

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

      • Pragati11's avatar
        Pragati11
        Super User
        2 years ago

        HI Anonymous ,

         

        If you can't share the screenshots ot the perocess you are following, I won't be able to understand your issue properly.

        What measure are you moving to table visual?

        You said matrix earlier and now you are saying table visual.

        Apologies but can't help until I see a details on your scenario. 🙂

         

        Also at my end, everything works perfectly fine.

        I have just moved a Total Sales measure in my table visual and the table only displays data when I make a selection in the slicer.

        I am able to apply visual level filter successfully.

         

        If this still doesn't work at your end, you will have to share details. You can create similar scenario using some dummy data and share screenshots.