Data showing when both items have empty value

[Anonymous]

Hi all,

First picture: BMW, BMW

Second Picture (drill down): Serangoon, York Hill

I have a doubt when checking on the data. In the first picture, it seems like both BMW have no data, but when I drill down I saw a 0% appeared in Serangoon which has completely confusing me. I believe there is no data in both BMWs however I am not sure why is there a data (0%) showing in Serangoon? 

Hope to receive some help!

Thanks.

[v-yulgu-msft]

Hi @Anonymous,

Please provide some sample data to help us better understand your table structure. Also, please tell us what measures/columns did you add to the chart.

Regards,
Yuliana Gu

[GilbertQ]

Hi @Anonymous

Does your data have null values or zero values?

If it is NULL by default it will not show the data, whilst if it is zero it will show a zero value

[Anonymous]

However at the first layer (first picture), both BMWs show null values. Doesn't this mean that the drill down layer will not show any values including zero value?

Thanks for the reply!