Issue with Pie chart disappears when no data to show

[Former Member]

Hi,

I have configured 3 pie charts, 1 pie chart is configured to show regions actual sales in percentage. This chart disappears when there is no data for any of selected month. However the other 2 pie chart just show global actual sales stays and show 0. Please share any solution or workaround to show Pie chart on dashboard in no data as well.

Tech: SAP BO Dashboard 4.1 SP3

Thanks,

Anurag

[Former Member]

Hi,

Try removing the ignore blank values option

Thanks

Manish

[Former Member]

Hi Manish,

Ignoring blank values doesn't work 😞

Regards,

Anurag

[Former Member]

Hi Anurag,

You can work around as below.

In the value part,while mapping use the below logic.

Suppose you are getting data in F3 cell.Then G3 cell formula will be Cell G3=If(f3="",0,f3).Then map value part with new formula cells G3.

Hope this helps.

Best Regards,

Venkat