Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

KPI Indicator shows null when the data value is actually 0

Hello, I'm trying to get a KPI Indicator visual to display a current value of 0%. It just shows a null value instead. The odd thing is that I have no null values in my data. The trending line itself ...
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    Problem solved.

     

    I created a new pbix file from scratch with nothing other than a table with data and a default KPI Indicator. Now the zero appeared in the visual with no problem. Hmm....

     

     

    So I must have basically broken the visual. I looked the custom format and there was the issue. When I remove the format, the zero appeared. 

     

    I changed the Custom format field from #% to 0% and now the value of zero with a percent sign as a suffix appears when the value is 0. 

     

    When the value is greater than 0, the data is still displayed exactly as before, which was always fine. 

     

    Thanks to pranit828  for your help. I appreciate all of your suggestions!

     

    Landshark

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous 

I would use 

FORMAT([Measure],"#.00")

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Problem solved.

 

I created a new pbix file from scratch with nothing other than a table with data and a default KPI Indicator. Now the zero appeared in the visual with no problem. Hmm....

 

 

So I must have basically broken the visual. I looked the custom format and there was the issue. When I remove the format, the zero appeared. 

 

I changed the Custom format field from #% to 0% and now the value of zero with a percent sign as a suffix appears when the value is 0. 

 

When the value is greater than 0, the data is still displayed exactly as before, which was always fine. 

 

Thanks to pranit828  for your help. I appreciate all of your suggestions!

 

Landshark