Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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!

 

Thanks.

Need Help
Show and Tell

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    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's avatar
      Anonymous
      Not applicable
      9 years ago

      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!

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    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