Display or not display visuals according to selection in slicer
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”.
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) ?