Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Data showing when both items have empty value

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!



Super User III
Super User III

Hi @beekee


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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

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!


Hi @beekee,


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.


Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors