cancel
Showing results for 
Search instead for 
Did you mean: 
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

Accepted Solutions
Moderator v-viig
Moderator

Re: power kpi matrix

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

6 REPLIES 6
Moderator v-viig
Moderator

Re: power kpi matrix

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

VivianX
Frequent Visitor

Re: power kpi matrix

 

 

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

 

Microsoft v-evelk
Microsoft

Re: power kpi matrix

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

VivianX
Frequent Visitor

Re: power kpi matrix

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.

Microsoft v-evelk
Microsoft

Re: power kpi matrix

Yep, you are right.

I forgot to mention this fact.

 

Thanks!

 

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

Highlighted
Julien_F Helper I
Helper I

Re: power kpi matrix

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

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors