2942558 - No data is available for the chart to render error occurs when using a live model with some null values in SAP Analytics Cloud (SAC)

When using some null values in a measure and doing a ranking base on the associated dimension

the error No data is available for the chart to render will happen.

• 2020.8.15 and Higher 

1.  Create a chart using a dimension and measures containing some null 
2.  Do a ranking eitehr top or bottom
3.  The error No data is available for the chart to render will happen

 some of the dimension values are associated with some null values for the measure selected

you can fix the issue at 3 levels

1. In the source system for example Hana you can create a a new calculation measure using a formula to set to 0 when the value is null
2. In the SAC model, in the measure section, you can add a new formula as IF(ISNULL([Measure] ) , 0,[Measure] )
3. In the Story, you can also create a new measure with the formula IF(ISNULL([Measure] ) , 0,[Measure] )

As you do remove the null values from the measure then you can do the appropriate ranking

SAC, no data, chart, null values , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem