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.

irishakir's avatar
irishakir
Frequent Visitor
8 years ago

In my situation: the less value the better. On November the second item is better because it has a zero value, but on October there is no information about the second item while looking on visualisation user may think that the second item is better on October too. So, I want to make a difference between the blank and zero values. Maybe, something like this:

emarc1's avatar
emarc1
Advocate II
8 years ago

If you conditionally format a table, you can get it to format blank cells differently. I'll often filter the blanks so the cells have a grey background.

 

You could also make a calculated column that has a text string warning that there's no data that could be displayed alongside.

 

IF( 
    Table[Column] = BLANK(),
    "No data",
    BLANK()
)

Not sure how I'd incorporate it into a bar chart, short of a custom visual.