Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Slicer Background color based on selection on dropdown format

Hi,

I have some requirement related to slicer background colour I will just explain the context here suggest me if we can achieve this or not.

Scenario: I have created a report having 3 slicers and based on selection of 3 slicers below the table visual interacts with the filters. but the requirement is if user selects any value from any of the slicer the background colour of the slicer becomes orange else normal white colour.

 

I tried with the dax but not workout. Can someone please help me to achieve this. Below the screen shot for reference.

 

1. If nothing is selected

 

1. If something is selectedy

 

I really appreciate if you can solve this.

 

Thanks

 

 

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi,

      Thanks for your quick response, I also tried this earlier its working fine for me. if its one or two filters we can handle this approach. In my report there are huge filters on each screen mostly 40 filters implemented overall the report in all the scree. so best of my knowledge this is not a best approach if possible can suggest some other approach if its fits for my requirement.

      Below is the screenshot what I was implemented.

      Thanks You so much for your inputs on this.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi,

        Thamks for your inputs onthis. as of now we not found any solution still I am looking for the suggestions. The same I developed in one of the POC and showed to the business, but unfirtunately they are not accepted it. still looking for the alternatives.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

     

    As far as I know, there is no other way to simplify setting the background color for multiple slicers, and BIswajit_Das  reply is a great alternative.

    You can submit an idea for it at Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.