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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Pragati11 ,

      Sorry for misunderstnding. Here is the sample data Snippet,

      Slicer > Customer Name; which is a column in my Table 
      Count > Matrix Visual; which is a measure 
      If I create,
      Filter Selected =
      IF (
          CALCULATE (
              HASONEVALUE ( Client[Customer_Name] ),
              ALLSELECTED ( Client )
          )
              = TRUE (),
          1,
          2
      )

       

      If I try to apply the "Filter Selected" measure on my Matrix Visual, but i can't apply on it.

      I can not dropdown and Select "1".  You could do it in your example, maybe because your columns are directly coming from your data, they may not be measures. Hope you have understood the problem. If not, let me know I will explain again but want to solve it anyow. 


       

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