cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Therseb
Helper I
Helper I

grey out filters with no data?

Hi,

I have some issues with the slicers in Pwer BI.

 

When I have two slicers that interact with eachother, and one slicer causes a category of the other to have no data, it just removes the category - I would like the slicer to still show the option, but greyed out.

Example:

#GenderNationality
1maleUS
2femaleUS
3femaleGER

 

I have a slicer for Gender and Nationality.

If I select "male" on one slicer, then "GER" on the nationality slicer will disappear...however, I would like this category to stay and just be greyed out.

 

Is there an option to do this?

 

Thanks!

1 ACCEPTED SOLUTION
Ailsa-msft
Community Support
Community Support

Hi @Therseb ,

The interaction of Standard Slicer just support filter and none .

If you don’t want two slicers interact each other cause the data of one slicer disappear , you can Edit interactions ,choose none and the two slicers will not interact each other .The slicer can still filter data table .

Ailsa-msft_0-1618971097123.png

Ailsa-msft_1-1618971097125.png

Ailsa-msft_2-1618971097127.png

Best Regards

Community Support Team _ Ailsa Tao

 

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

View solution in original post

2 REPLIES 2
Ailsa-msft
Community Support
Community Support

Hi @Therseb ,

The interaction of Standard Slicer just support filter and none .

If you don’t want two slicers interact each other cause the data of one slicer disappear , you can Edit interactions ,choose none and the two slicers will not interact each other .The slicer can still filter data table .

Ailsa-msft_0-1618971097123.png

Ailsa-msft_1-1618971097125.png

Ailsa-msft_2-1618971097127.png

Best Regards

Community Support Team _ Ailsa Tao

 

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

amitchandak
Super User
Super User

@Therseb , I doubt that is possible with a standard slicer

Log an idea: https://ideas.powerbi.com/ideas/

or check custom visual - https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s || 50+Power Query List Functions : Learn Power Query List
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors