Forum Discussion
How to show zero values in a matrix
Hello guys!
I need a lot of help with the following:
In an matrix, I put the priority as a criterion and the rankings as follows in the image:
In this case, there is also a priority "Critical", but depending on what was filtered in "Final Group", this priority does not appear as it has no value.
I would like to know if it is possible to make it so that even having no value, it is possible to show the priority "Critical" with a value of zero.
I don't know if I made myself clear, I tried to explain as best I could!
Thanks for your attention in advance.
Hi avitoriasrocha !
Try an if condition like:IF( value = BLANK(), 0, value )Let me know if that helps!
4 Replies
Hi avitoriasrocha !
Try an if condition like:IF( value = BLANK(), 0, value )Let me know if that helps!
I found an even simpler solution here
I'm answering from my phone so I'll do my best to explain without screenshots.
One way to do it...
- Select the visual that you want priority to show all for.
- In the field well (I think that's what it's called) in the visualisation pane on the right, where you drop your fields in for the visual, right click on priority and select 'Show items with no data'
Let me know if that helps.
You can try the following measure:
Show 0 if critical = IF ( SELECTEDVALUE ( 'Priority Table'[Priority] ) = "Critical", COALESCE ( [Your measure], 0 ), [Your measure] )
