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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

ccakjcrx Hey!

 

Null or 0, it makes no difference as both return a low bar on the graph. I need to indicate no data, null or 0 in an explicite way, otherwise it's confused with good performance.

 

Thanks for the walkthrough though! I didn't know you could replace values like that.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Could you create a Measure and include an IF(ISBLANK() in it and if so set it to the MAX of the value or some static number like 100? Not ideal, but at least it would not be zero. Also, you could potentially create another measure for a tooltip so that you could show "No data" when they hover over the value.