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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

So, are you saying that you have some categories or groups like:

 

Category

red

green

blue

 

And you have some data like

 

Category,Incidents

red,1

red,2

green,4

red,5

green,6

 

So, no blue. Something along those lines?

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

    • 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