Forum Discussion
How to get zero values in a Matrix visual that counts values based on column?
Hey All,
When making a table or matrix in Power BI the zero values never show up. Is there a method to show a zero in these value cells? My input data for the visual is:
- Rows: nested list full of project rows
- Columns: 4 options that need to be counted seperately
- Values: The count of all project rows that are equal to one of the four column options, and the fraction over the total amount of projects.
Thank you in advance!
Cheers
4 Replies
- amitchandak
Super User
Anonymous , Add +0 to your measure
Hey amitchandak I'm not using any measure for this matrix. I use the built-in count function.
- amitchandak
Anonymous , Create a measure and use that , if that can solve purpose
measure = count(Table[Column])+0
