Hello all,
I have been requested to develop a dashboard with the described case below and for the moment I did not find any solution.
In the dataset, I have a table STUDY that contains several columns and among them “STU_CODE” and “STATUS”.
STU_CODE | STATUS |
Study_1 | Active |
Study_2 | Stopped |
... | ... |
On a page of a dashboard, I would like to have several visuals visible when the study that is selected through a slicer is “Active” and not visible when the selected study is “Stopped” (the column “STATUS” is not present on the page)
To clarify what I wish:
The selected study is “Active”, the visuals are displayed:
The selected study is “Stopped”, the visuals are not displayed:
Do you know a way to synchronize the presence or the absence of visuals according to a value of a column that is not present on the page (here STATUS) but that is induced thanks to the selection in a slicer of another column (here STU_CODE) ?
Thank you for your help
Instead of a slicer dropdown use buttons wired to bookmarks. They are the only robust way to control visual visibility .
Hi,
I have been proposed a solution to my question that I wish to share with you:
Show or Hide a Power BI Visual Based on Selection ✅ - Excelerator BI
Very interesting !!
ClaudeG
That's been known for a while. You lose the interactivity.