Forum Discussion
Replacing blanks with 0 in matrix visual
Hi,
I currently have this matrix with many blanks in dates where there are no values. The original data does not display zero, so I am trying to find a way to change the blanks in this visual to display zeroes instead. Would anyone know how to go about this? Thank you, any help is appreciated!
Anonymous , In this case you could use below formula.
Measure = calculate(count(table[name]))+0
7 Replies
Samarth_18Community Champion
Hi Anonymous ,
If its values directly coming from the column then you can try any of the below code by creating a measure.
Measure = max('table'[column])+0Measure = coalesce(max('table'[column]),0)Thanks,
Samarth
Hi,
The issue is that my original data does not contain the missing values. It skips over those. I tried the above measures but it displays all the names instead of counting them. This is how it is currently organized:
I would go to the original data and trasnform the values to zero, but not all days have values for each location in the source data.
Thank you for any help!
- Samarth_18
Anonymous , In this case you could use below formula.
Measure = calculate(count(table[name]))+0