topic Re: Rendering graph with null values, Power KPI Matrix in Custom Visuals Development Discussion

Rendering graph with null values, Power KPI Matrix

Anonymous — Thu, 01 Nov 2018 10:40:36 GMT

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 for every day through out the month.

Now, it appears the graph doesn't render if Actual value is null. The behaviour I would expect is the graph redering if either Actual value OR Comparison value is not null.

I've tried the feature "Treat zero values as nulls" but see no use for it in this case, since it creates a drastic drop in the graph that would likely lead to misinterpretations.

The behaviour I'm looking for is shown in the Power KPI Visual small multiples example in this blog post: https://powerbi.microsoft.com/en-us/blog/balanced-scorecards/

Re: Rendering graph with null values, Power KPI Matrix

v-viig — Fri, 02 Nov 2018 10:33:28 GMT

This is expected behavior for Power KPI Matrix because it was designed in such way.

Our recommendation is to filter null values out using Power BI Slicers or page level filters.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Rendering graph with null values, Power KPI Matrix

Anonymous — Fri, 02 Nov 2018 13:12:48 GMT

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.

Re: Rendering graph with null values, Power KPI Matrix

v-viig — Tue, 06 Nov 2018 09:23:19 GMT

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

pbicvsupport@microsoft.com

Re: Rendering graph with null values, Power KPI Matrix

dm1904 — Wed, 02 Jan 2019 10:00:48 GMT

This is my biggest dissapointment with the visual. It is otherwise brilliant but this one issue is preventing us from using it

Re: Rendering graph with null values, Power KPI Matrix

Anonymous — Thu, 03 Jan 2019 13:56:51 GMT

@dm1904Have you found any other better solution for visualizing KPIs in a tabular layout?

Re: Rendering graph with null values, Power KPI Matrix

dm1904 — Thu, 03 Jan 2019 14:00:44 GMT

@Anonymous No I haven't this is the best I've found to be fair, at least for my use case. I just need to live with not showing future comparison values

Re: Rendering graph with null values, Power KPI Matrix

dm1904 — Thu, 03 Jan 2019 14:01:06 GMT

@Anonymous No I haven't this is the best I've found to be fair, at least for my use case. I just need to live with not showing future comparison values

Re: Rendering graph with null values, Power KPI Matrix

Anonymous — Sat, 05 Jan 2019 04:28:29 GMT

Yea me too. It's just that it takes the edge away from accumulating monthly graphs, to say the least. But the fact that the related visual Power KPI renders null values splendidly gives me some hope that the Power KPI Matrix will also do it in time.

Re: Rendering graph with null values, Power KPI Matrix

v-viig — Tue, 08 Jan 2019 14:04:11 GMT

Yes, Power KPI Matrix will support the same but we do not have any ETA so far since our focus is to migrate it to versoned API and open source.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Rendering graph with null values, Power KPI Matrix

vh_ — Sat, 12 Oct 2024 09:18:43 GMT

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.