Forum Discussion

irishakir's avatar
irishakir
Frequent Visitor
8 years ago
Solved

Labels for Blank Values

Hello! I have blank values and zero values. They have to be visualised. I use "show items with no data" to show the blank values, but I also want user to know, that there is no data, so, I need to a...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Thanks for the additional details.

     

    The easiest way to turn blanks into zeros is to use a measure for your Values field that has a "+0" in it. Like this:

     

    Quantity = SUM(Dataset[Value]) + 0

    If you want to make it more obvious that there's a zero value in your chart, turn on data labels.

     

    The one kink you might run into is that if, for example, there are no lines of data for series 2 in October, there will be a blank space instead of a zero for that month. I don't think there's any way around that.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for the additional details.

 

The easiest way to turn blanks into zeros is to use a measure for your Values field that has a "+0" in it. Like this:

 

Quantity = SUM(Dataset[Value]) + 0

If you want to make it more obvious that there's a zero value in your chart, turn on data labels.

 

The one kink you might run into is that if, for example, there are no lines of data for series 2 in October, there will be a blank space instead of a zero for that month. I don't think there's any way around that.

irishakir's avatar
irishakir
Frequent Visitor
8 years ago

Thank you!