Forum Discussion
Matrix Visualization
I have a matrix visualization in power bi. There are 'Dept' in the Rows and 'Year' in the column. And we have 'CountID' in the Values. Now a matrix is being created. There are a total of 8 Dept but o...
devesh_gupta No it's giving same results as before. It's not showing 0 as values where no CountID exists.
asad-mustafa-dc Let's try these simpe steps:
Select the matrix visual.
On the Fields pane, locate the "Dept" field under the Rows section.
Click on the dropdown arrow next to the "Dept" field to open its context menu.
Check the option that says "Show items with no data." This option will ensure that all departments, even those without any CountID values, are displayed in your matrix visual.
If you find this insightful, please provide a Kudo and accept this as a solution.
asad-mustafa-dc Community support has provided some solution above to this problem... Have you tried if that's working or not?