Forum Discussion
Substitute NULL values on 0 in Matrix visulisalization
Hi Mikhail_Lourie ，
Check the similar thread below:
https://community.powerbi.com/t5/Desktop/Display-zero-instead-of-blank-in-matrix/td-p/193745
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Super UserHi. This might be a question for Desktop or dax forum. It's not the best practise to transform blanks but if that what you need you can create a measure like this:
AVG_Measure = AVERAGE(Table[Minutes_duration]) + 0Adding the +0 at the end of the measure will change the blank values to 0 and won't modify any other value.
Hope this helps
It doesn't help ...
The reason is that we don't have such values in a Custom Column (if there are no values that get into the current bin)
We need to put 0 for column items that are not in the Custom Column values but could be according to combinatorics rules
Hi Mikhail_Lourie ，
Check the similar thread below:
https://community.powerbi.com/t5/Desktop/Display-zero-instead-of-blank-in-matrix/td-p/193745
Best Regards,
KellyDid I answer your question? Mark my post as a solution!Thank you very much Anonymous .
You've made my day!!!:)