topic Re: power kpi matrix in Custom Visuals Development Discussion

power kpi matrix

Gourd_J — Thu, 13 Sep 2018 20:20:17 GMT

I'm trying to use the Power KPI Matrix for the first time. My data source is a SSAS Multidimensional cube with KPIs. To simplify things I've downloaded and processed the Adeventureworks2014 MD DW to my local SQL 2014 instance and processed the example cube from here:

https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-modeling-adventure-works-tutorial?view=sql-server-2017

Here are the steps I follow:

connect to the SSAS Database
drop a Power KPI Matrix on the page
drag the Date\Fiscal Date\Fiscal Year to the KPI Matrix's Date Fields
From Measures, drag the Product Gross Profit Margin\Value to the KPI Matrix's Actual Value field. (the Matrix not shows a row with "As of Date" populated, "Metric Name" populated, "Current Value" populated, and a spark line showing).
I drag Product Gross Profit Margin\Goal to the KPI Matrix's Comparison Value field and nothing shows up in the "Comparison Value" column of the KPI Matrix.
I drag Product Gross Profit Margin\Status to the KPI Matrix's KPI Indicator Index field and nothing shows up in the "KPI Status" column of the KPI Matrix.

What do I need to do to have the Comparison Value and KPI Status columns be populated? Am I using the right values, am I putting them in the wrong config fields?

PS, having an step-by-step example using, say the AdventureWorks DB, would be awesome!

Thanks

Gord

Re: power kpi matrix

v-viig — Mon, 17 Sep 2018 12:50:49 GMT

Please go through Power KPI Matrix sample report to understand how this custom visual works.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: power kpi matrix

VivianX — Wed, 01 May 2019 18:11:54 GMT

Hi Ignat,

I have downloaded your linked file. When I click "Sparklines" chart, i shows something as below. Do you know what the meaning of "KPI status" an "Second KPI status"?

Below is the one example from me. Thank you a lot!

Re: power kpi matrix

v-evelk — Mon, 13 May 2019 14:14:20 GMT

Hi,

"KPI Status" shows difference between actual and comparison values.

"Second KPI Status" shows difference between actual and second compariosn values.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Re: power kpi matrix

VivianX — Mon, 13 May 2019 14:24:02 GMT

Hi,

Thank you for your reply @v-evelk .

You are correct. But one thing I want to add more detail:

"For "KPI status", it will return the value of KPI Indicator Value, and if there is no filed or measure on it. It will calculate the Variance between Actual value and Comparision Value automatically.

And for "Second KPI status", it will return the value of Second KPI Indicator Value, and if there is no filed or measure on it. It will calculate the Variance between Actual Value and Second Comparision Value automatically."

Hope this will be beneficial for other users.

Re: power kpi matrix

v-evelk — Mon, 13 May 2019 14:48:41 GMT

Yep, you are right.

I forgot to mention this fact.

Thanks!

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Re: power kpi matrix

Julien_F — Sat, 21 Mar 2020 15:02:52 GMT

@v-viig WOW Amazing!

How didyou do for building the fact and dim table? I mean if I understood wel it is a fact KPI table where you have different types of KPI in different format linked to a DIM KPI table? I have a star schema and I would realy like to build such a schema for KPI reporting,

Thx a lot,

Re: power kpi matrix

Ali5457 — Thu, 03 Nov 2022 01:30:50 GMT

Hi,

Is it necessary to build that KPI data model to be able to see the KPI status? I have just defined a KPI001 status measure as below but I cannot see anything in the KPI status.

Brelow is the setting:

It's worth mentioning that I cannnot add KPI001 to the table as a column as it's caclulated based on a couple of measures so it has to remain as a measure. It's value is a % like 90% and the KPI001-2 target is 0.9.

Thanks,

Ali