Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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):
2) Selecting one item, and behaviour of the rest of windows (filtered only applicable items);
3) Desired behaviour (in grey or similar);
Is this possible?
Thank you in advance.
Solved! Go to Solution.
Hi,
the answer by Samarth_18 is perfect.
To help i post the image where you can find the function
By clicking on
you can change the interactions between your slicer.
Pay attention that, if your slicer are too close together you mighyt not see the button
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
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
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
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
Thank you, I will do in this way... please vote for the idea, hehe
best regards
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
49 | |
42 | |
39 | |
38 |