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.
I have a matrix that has months along the top. If I filter by month in a visual filter, it hides the columns that have no data, if I filter by month on the filter bar, the months with no data remain but remain empty.
Is there a way to change the way the filter bar interacts with the reports so that it hides the empty columns?
HI @Anonymous,
I don' think you can use filter to achieve this, perhaps you can write a measure and use on 'visual level filter' to check and remove blank data bars.
Applying a measure filter in Power BI
If you are confused about coding formula, it will help if you share some dummy data to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
@Anonymous , refer if this can help
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
@Anonymous , no option for interaction with filter pane
User | Count |
---|---|
81 | |
76 | |
70 | |
69 | |
54 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |