Forum Discussion

Gourd_J's avatar
Gourd_J
Helper I
7 years ago
Solved

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-tutorial?view=sql-server-2017

 

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

7 Replies

    • VivianX's avatar
      VivianX
      Frequent Visitor
      7 years ago

       

       

      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!

       

       

      • v-evelk's avatar
        v-evelk
        Microsoft Employee
        7 years ago

        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
        [email protected]

    • Julien_F's avatar
      Julien_F
      Helper I
      6 years ago

      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. 

  • Ali5457's avatar
    Ali5457
    Frequent Visitor
    3 years ago

    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