Forum Discussion
How 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 |
| 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
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:
3 Replies
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.
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:
