Forum Discussion
Blank Values
How to display blank values as NA , where rest of the values in column contains Number(Whole Number) in Column chart.
Hi Anonymous ,
As far as I know, this cannot be achieved in a bar chart. Measure can only be one data type. NA and number are not the same data type. The value field in the bar chart is the aggregated number type.
This can be achieved if it is in a table or matrix.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Without doing any research, I would suggest replacing the blank with 0 in the source table in the model then using a measure with Switch to replace the 0 with NA.
Alternative option would be to add a calculated column as per this post then the switch.
https://community.powerbi.com/t5/Desktop/Replacing-Blanks-with-0/m-p/418624Hope this helps
Hi Anonymous ,
As far as I know, this cannot be achieved in a bar chart. Measure can only be one data type. NA and number are not the same data type. The value field in the bar chart is the aggregated number type.
This can be achieved if it is in a table or matrix.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
