Not showing blank data in stacked column chart

[Anonymous]

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 

Animal	character
Cat	Good
Dog	Good
Cat	Bad
Dog	Very bad
Elephant

@Ashish_Mathur 

@v-lid-msft Any suggestions

[Anonymous]

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]

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]

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