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,
in my matrix-visual "Multifilter" (right) filters according to "Versicherungsprodukte" (top) - but nevertheless other columns still appear, even if they do not have Results:
How do I make the rows for the other columns (containing names, logo, do-they-have-special-products/leafs) disappear?
At the top of my head I think I need to create a measure for the rows:
But is there an easier way I simply don't know?
Hi @Tontaube2
here are 2 ways for your reference,
(1) change the setting of the visual-level filter,
(2) Or you can change the measure, add a judgment statement to measure (see below)
Don't forget to uncheck this option: show items with no data.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @lbendlin ,
unfortunately it's already unchecked.
I've noticed: The behaviour only occurs if I drop a measure to values. Once I've made a custom column out of it and dropped this in, everything was fine.
In the rows section of your visual use a dropdown next to one of the fields and uncheck "Show items with no data"
User | Count |
---|---|
65 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
119 | |
41 | |
40 | |
28 | |
22 |