Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

How to keep showing non-applicable elements (in grey) in filters?

Good morning,

 

I am a very new user in Power BI; I have prepared a report sheet based on  a query in which I have included several windows for Data Segmentation.

 

If I choose an element in one window, the rest of the windows became filtered by the valid selection choices... but I would like to see in them also the non-valid options (maybe in grey).

 

An example:

 

1) Complete report panel (no selection):

vgomez_0-1644910143332.png

 

2) Selecting one item, and behaviour of the rest of windows (filtered only applicable items);

vgomez_1-1644910177742.png

 

3) Desired behaviour (in grey or similar);

 

vgomez_2-1644910252506.png

 

Is this possible?

 

Thank you in advance.

 

 

1 ACCEPTED SOLUTION

@Anonymous I dont think Power BI support such scenario but you can share this in ideas for Power BI.

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

View solution in original post

8 REPLIES 8
serpiva64
Solution Sage
Solution Sage

Hi,

the answer by Samarth_18 is perfect.

To help i post the image where you can find the function

serpiva64_0-1644911936295.png

By clicking on 

serpiva64_1-1644911992894.png

you can change the interactions between your slicer.

Pay attention that, if your slicer are too close together you mighyt not see the button

 

 

 

Anonymous
Not applicable

yes, it works, but I would like to see not applicable elements in grey and without the checkbox... to control which options are valid (still selectable) and which ones are not.

is that possible?

thank you very much for your kind support

Samarth_18
Community Champion
Community Champion

Hi @Anonymous ,

 

You can disble filter with edit interaction in Power BI.

 

Thanks,

Samarth

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

Anonymous
Not applicable

How could I do this?

I will try it and revert back my experience.

By the way, thank you very much for your prompt answer.

 

@Anonymous You can refer to below article to implement it.

 

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions 

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

Anonymous
Not applicable

Hi,

The filters works almost as desirable... the unique behaviour that does not comply with my goal is to appear the not applicable elements in grey and without the checkbox.
any help? is this possible?

thank you a lot again

@Anonymous I dont think Power BI support such scenario but you can share this in ideas for Power BI.

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

Anonymous
Not applicable

Thank you, I will do in this way... please vote for the idea, hehe

best regards

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.