How to hide a visualisation depending on a filter ?

[Gwendaline_p]

Hi everyone ,

I have a question on how to hide a visualization depending on a filter.

I have this table :

Level 1	Level 2	Level 3	Count
A	B	E	10
A	B	F	15
A	C	G	20
A	C	H	30
A	D	Unknown	40
I	J	Unknown	10
I	K	Unknown	20
I	L	Unknown	30

And I have 3 filters :

- First filter on the first column (level 1)

- Second filter on the second column (level 2)

- Third filter on the third column (level 3)

And 3 bar charts : 1 bar chart per filter

My question : is it possible to hide, for example, the third bar chart when I choose something with the first and the second filter ?

For example :

I choose level 1 = A and level 2 = B and the third graph is not here anymore like this :

Thanks a lot for your help !

Gwendaline

[Vvelarde]

@Gwendaline_p

Hi, using this could simulate that the chart don't exist.

CountM =
IF (
    FIRSTNONBLANK ( Table1[Level 1], Table1[Level 1] ) = "A"
        && FIRSTNONBLANK ( Table1[Level 2], Table1[Level 2] ) = "B",
    BLANK (),
    COUNT ( Table1[Count] )
)

To a better look you can disable the Y Axis and the Title.

[Greg_Deckler · Accepted solution]

To the best of my knowledge, there is no way to conditionally hide a visual.  Would make agreat Idea though if it is not already out there. Seem to be a few different variants:

https://ideas.powerbi.com/forums/265200-power-bi?WT.mc_id=Community&query=conditionally%20hide%20vis...

[Gwendaline_p]

Hi @Greg_Deckler ,

Thanks a lot for your answer.

I vote for a variant Idea.

Kind regards ,

Gwendaline