Is there a way to Replace (Empty) with "No Data" in y value axis of KPI Chart.

[HITESH SAHOO]

Hi All,

My requirement is to show "NO DATA" instead of Empty in KPI Chart(refer ro below screenshot). Is it possible

Please let me know.

[David Boot-Olazabal]

Hi HS,

 

You can do it in two ways:

- create a calculated column like this one and use it in the KPI chart:CASE WHEN [sales13] IS NULL THEN 0 ELSE [sales13] END

- In the Data Panel, replace the Empty values with specific value. You can open the data panel via the middle icon on the left hand side or via the View --> Data menu. Then select the gear icon to view the content of the data.

See my attached dashboard for the two examples.

Kind regards,

David

[HITESH SAHOO]

Actually, your above solution is very helpful, but still instead of showing empty can we show "No Data" as string 

 

Thank you so much for this solution. 

 

 

[David Boot-Olazabal]

Hi HS,

 

When you use the calculated column option, instead of 0 you should be able to use "No Data" instead: CASE  WHEN [sales13] IS NULL THEN "No Data" ELSE [sales13] END.

 

You probably can do the same when replacing the EMpty Values with a specific value (have not checked it yet) such as "No Data".

 

Kind regards,

 

David

[HITESH SAHOO]

As [sales13] is integer and 'No Data' is string, there's a problem, not valid expression. 

 

So is there any workaround for this  

 

Thanks for helping. 

[David Boot-Olazabal]

Hi HS,

Yes, I see it. It sometimes works, but most of the times it does not, unfortunately.

But you can use the formatting of the values to achieve the same though. See the attached dashboard and screenshot how to do it. I have used this custom format for the Sales column:#.###;-#.###;NoData And that gives you the desired output.

Kind regards,

David