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

Greg_Deckler Correct, except each category is distinct. (so red would only feature once, and with its number)

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft 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


  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    v-huizhn-msftGreg_Deckler

     

    Thank you for your suggestions.

     

    I already have a measure that returns BLANK IF 0, and that works as expected.

     

    I like the tooltip idea, the only issue is, you need data to hover over to reveal the tooltip.

     

    I could force a static number in the event of no data, I just tried this with numbers that aren't going to interfere with the results (like minus numbers) but this is just too inelegant unfortunately.

     

    I've considered creating a table of categories that have no data, but this means the user has to cross reference that table with the graph to pick out the offenders, and also isn't ideal.

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      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

        Good idea! Thanks

  • 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