Forum Discussion
Rendering graph with null values, Power KPI Matrix
I want to use Power KPI Matrix to show a monthly accumulated KPI with Actual value and Comparison value. In the dataset the Actual value is null for days after today, and the Comparison value is set ...
You can try and change all Actual, Comparison and Second Comparison value to return a small non-zero number like 0.00001 if the value is Blank() or 0.