Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 data set.
I have managed to get both done independently but cannot get them working together. I implimented 'all categories shown' by using a reference table with all possible values contained and I implimented the ordering done by using an index/ordering table.
Below is with all categories shown and then with categories in the right order
Is there a way to impliment both at the same time?
Thanks in advance for any help provided
Regards
Michael
Solved! Go to Solution.
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
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