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 ...
I dont see how your recommendation to filter nulls would help. If I filter null values from the Actual value the graph doesn't render, even if I have Comparison values.
Why would you want the Power KPI Matrix to behave differently than the Power KPI visual and Excel? Both of which render the graph if any of the series contain non-nulls.
It was required by specs. We'll consider an ability to render sparklines with null values.
For now, we recommend to filter null values out just for Power KPI Matrix by using visual level filters.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
This is my biggest dissapointment with the visual. It is otherwise brilliant but this one issue is preventing us from using it
