Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Not showing blank data in stacked column chart

Hi Team,

 

Below is the sample table which i have used to create a stacked column chart .However im not able to see Elephant data as blank 

 

Animalcharacter
CatGood
DogGood
CatBad
DogVery bad
Elephant 

Ashish_Mathur 

v-lid-msft Any suggestions

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous,

    I don't think this is possible to show blank/zero data labels in charts. AFAIK, Power bi visuals will auto-hide data labels with blank or zero results. 

    For your requirement, I'd like to suggest you create table visual and enabled 'show items with no data' option to display these blank value records. (table visual allow to display records with 'do not summarize' mode, you can use this to force display blank data records)

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
       

      I tried using a measure but it is returning as 1 ,is there any alternative to this which can return elephant to '0'

      Anonymous Nathaniel_C amitchandak 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

        When your data label equals '0', its graph will be filtered by visual itself. (blank and zero value will be filtered)

        I haven't found any methods to display these blank and zero values in chart, maybe you can try to replace zero value to other values (e.g. negative) to force display it or create visuals which allows displaying 'not summarized' values. (e.g. table)
        Regards,

        Xiaoxin Sheng