Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Gourd_J
Helper I
Helper I

power kpi matrix

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-tut...

 

Here are the steps I follow:

  1. connect to the SSAS Database
  2. drop a Power KPI Matrix on the page
  3. drag the Date\Fiscal Date\Fiscal Year to the KPI Matrix's Date Fields
  4. 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).
  5. 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.
  6. 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

1 ACCEPTED SOLUTION
v-viig
Community Champion
Community Champion

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

View solution in original post

7 REPLIES 7
Ali5457
Frequent Visitor

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.

 

Ali5457_0-1667436586472.png

 

Brelow is the setting:

 

Ali5457_1-1667436633343.png

 

Ali5457_2-1667436666274.png

 

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

 

 

 

  

v-viig
Community Champion
Community Champion

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

@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, 

 

J. 

 

 

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!

 

KPI Status.JPG

 

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

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.

Yep, you are right.

I forgot to mention this fact.

 

Thanks!

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors