Forum Discussion
Matrix Visual - Filter/Exclude/Hide empty/blank multi level column measure
- Anonymous4 years ago
Hi xkoby001 ,
I'm afraid that there is no elegant way to implement it. Anyway, you can use the following method as a workaround...
Power BI > Hide NULL or BLANK values in Matrix visual
1. Toggle off the Word wrap option under the Column headers tab
2. Adjust the size of the Values field(s) with all blank values (for example: vs_BG%) you need to hide small enough to be invisible manually
And you can share some sample data and your expected result with backend logic and special examples. It is better if you can provide a simplified pbix file. Later we can provide you a suitable solution base on your provided info. Thank you.
How to upload PBI in CommunityBest Regards
Hi xkoby001
In thr filter pane adjust the settings for the ACT measure as Not Is Blank. I don't have a clear idea about the complicity of your report therefore you might need to lock the filter of some othe measure using the lock icon at the corner of each measure in the filter pane