Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Indicate 'no data' on graph - how to?

I have a data set, where it's quite possible that some entities have no data.   The issue is, in my case, when using a bar graph, a low bar indicates good performance. So when entities with no data...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Anonymous,

    For your feature request reveal the tooltip without hovering over, you can create an idea here.

    Thanks,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Anonymous,

Create a measure similar the formula below, and check if it returns correct result as Greg_Deckler posted.

measure=IF(sum(Table[Indicator])=BLANK(),0,sum(Table[Indicator]))


Please respond to us if you have other issue.

Best Regards,
Angelia


HarshaBatuka's avatar
HarshaBatuka
Frequent Visitor
8 years ago

Hi Angelia,

 

This measure was so help full, but instead of "o", can we include some text like "no records".

 

Thank you,

-Harsha