Forum Discussion
how show null values on graphs
Hi i have a sample graph below:
but unfortunately, if the value is zero, it is being cut out.. how do i make them the lines and the colors still connected?
Thanks in advance.
1 Reply
Create a measure that replaces the nulls with a 0, for example:
No_Null_Measure = IF(ISBLANK(SUM(TableName[ColumnName])),0, SUM(TableName[ColumnName]))Note: Change the expression accordingly if it's average or whatever other measure/calculation you have.
