Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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:
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:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
61 | |
59 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |