Forum Discussion
Show all rows in matrix visual - even when there are no values
Hi Anonymous ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Measure = IF( MAX('Table'[Value]) =BLANK(),"0",MAX('Table'[Value]) )2. Result:
Or if you click on the yellow label "Show items with no data", the values that are not displayed will be displayed as Blank()
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Measure =
IF(
MAX('Table'[Value]) =BLANK(),"0",MAX('Table'[Value])
)2. Result:
Or if you click on the yellow label "Show items with no data", the values that are not displayed will be displayed as Blank()
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
I tried this solution. Its not working when i am showing count for each cell. the Matrix is not showing the Row or column if the data cells are not available. if i show blank rows then its not showing anything but blank rows. How to show all rows and columns even if some cells are blank with count