Forum Discussion
Gwendaline_p
Helper I
Helper IHow to hide a visualisation depending on a filter ?
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 ...
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:
Vvelarde
Community Champion
Community Champion
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.