Forum Discussion
Matrix Visual - Filter/Exclude/Hide empty/blank multi level column measure
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 amitchandak ! Thank you for reaction!
Could you please give me more details, should I define a new one measure, which will combine my current measures?
...
Because two fields [PeriodAnalysis] and [Version] are text fields, they are in Column part of matrix.
[Value] in Values part of matrix contains fact values, [vs_XX%] are calculated measures.
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
