cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ClaudeG
New Member

Display or not display visuals according to selection in slicer

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:

ClaudeG_0-1682085348909.png

 

 

The selected study is “Stopped”, the visuals are not displayed:

ClaudeG_1-1682085348911.png

 

 

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

3 REPLIES 3
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors