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

VivianX's avatar
VivianX
Frequent Visitor
7 years ago

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.

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

    Yep, you are right.

    I forgot to mention this fact.

     

    Thanks!

     

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]