topic Re: Display or not display visuals according to selection in slicer in Custom Visuals Development Discussion

Display or not display visuals according to selection in slicer

ClaudeG — Fri, 21 Apr 2023 14:04:55 GMT

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

Re: Display or not display visuals according to selection in slicer

lbendlin — Thu, 27 Apr 2023 00:15:07 GMT

Instead of a slicer dropdown use buttons wired to bookmarks. They are the only robust way to control visual visibility .

Re: Display or not display visuals according to selection in slicer

ClaudeG — Tue, 09 May 2023 15:42:57 GMT

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

Re: Display or not display visuals according to selection in slicer

lbendlin — Tue, 09 May 2023 15:50:02 GMT

That's been known for a while. You lose the interactivity.