Forum Discussion
Solved
Matrix - Column order & Display with 0
Hi all I am new to Power BI but have lots of excel and SQL experiance. I am trying to use a matrix visual to show the columns in a custom order & display columns even if there are no values in the ...
hi M_Donovan
Just add "+0" in your measure formula
see more details by these link:
https://community.powerbi.com/t5/Desktop/show-items-with-no-data-as-0-instead-of-blanks/td-p/113160
https://radacad.com/replace-blank-with-zero-in-power-bi-visuals-such-as-card
By the way, the field in "Rows" and "Columns" need to from a dim table.
Regards,
Lin
v-lili6-msft
Community Support
Community Supporthi M_Donovan
Just add "+0" in your measure formula
see more details by these link:
https://community.powerbi.com/t5/Desktop/show-items-with-no-data-as-0-instead-of-blanks/td-p/113160
https://radacad.com/replace-blank-with-zero-in-power-bi-visuals-such-as-card
By the way, the field in "Rows" and "Columns" need to from a dim table.
Regards,
Lin