Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
76 | |
75 | |
46 | |
31 | |
27 |
User | Count |
---|---|
99 | |
91 | |
51 | |
48 | |
47 |