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 show up as blank, this is misconstrued as 'really good!'.

 

I need all entities present on the graph, so I can't simply deselect 'Show items with no data'. I need a way of indicating that the particular entity has no data.

 

I've tried searching for special indicators on graphs, or even having them display strings (i.e. "Error, no data") but no luck.

 

Any suggestions much apprciated.

 

 

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

12 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community 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
        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


  • ccakjcrx's avatar
    ccakjcrx
    Resolver I
    8 years ago

    Anonymous

     

    Hey!

     

    As with Greg_Deckler, I have to speculate concerning some of the characteristics of your problem because we don't have access to your data. 

     

    Is it the case that the entity (without a value) shows up as null in the data view in pbi desktop? If that is the case, you can go into the query editor, and replace the null values with 0. When in query editor, you simply:

     

    1. Select the desired column

    2. Click replace values

    3. Change null to 0

     

     

     

     

     

     

     

     

     

     

     

     

    If you close and apply, the model will update existing null values with 0 in the specified column, and your entities will show up in your bar chart.

     

     

     

     

     

    • 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.