Power KPI Matrix

[Rajiv_V]

I have 2 questions related to Power KPI Matrix 3.1.1.0 custom visual :

1. Is it possible to provide page navigation links within the same power bi to individual row level metrics for this chart?

2. I am trying to create KPI Indicator and value using the Power KPI matrix visual to track %MoM change, however the colored indicators are not visible. I have included the column for "KPI Indicator Value" and the value is showing correctly, however I am unable to understand what to include in the "KPI Indicator Index" field, am I doing this correctly?

Thanks for your help in advance.      

[johnbasha33]

Hi  

Alright, let's walk through both your Power KPI Matrix questions one by one — I'll explain it naturally but precisely! 🎯

---

1. Page navigation links within Power KPI Matrix rows

✅ Short answer:
Direct page navigation links are NOT supported inside the matrix rows natively.

💬 Longer explanation:

• Power KPI Matrix 3.1.1.0 is mainly built for metrics display, KPIs, and historical trends inside rows — not for navigation actions.

• You cannot embed a hyperlink or a page action directly into a row cell.

• Workaround?
  ➔ Use "Button" visuals separately with Dynamic Page Navigation based on a selected metric.
  ➔ Or you can create a separate Matrix/Table visual (not Power KPI Matrix) using URL icons/links, but not inside Power KPI Matrix itself.

  👉 If you really want navigation at row-level, you'd need to design something outside Power KPI Matrix (using tables/buttons).

  ---

  2. About KPI Indicator Value and KPI Indicator Index

  ✅ You're halfway correct!
  You're placing the KPI Indicator Value properly — that's the field that defines the metric you are evaluating (like % MoM change).

  BUT!
  KPI Indicator Index is separate and essential for showing the colored indicators.

  What is "KPI Indicator Index"?
  👉 It’s a field that classifies whether the KPI is Good, Bad, or Neutral.

  Power KPI Matrix expects:

  • A field (numeric or text) which represents the "state" of the KPI.

  • Typically:

    • 1 → Good (Green Up Arrow)

    • 0 → Neutral (Yellow Sideways Arrow)

    • -1 → Bad (Red Down Arrow)

      ---

      ✨ Example to make your Indicators work:

      Suppose you have %MoM Change measure.

      Now create another calculated column or measure like:

      KPI Indicator Index = 
      SWITCH(
          TRUE(),
          [%MoM Change] >= 5, 1,   // Green if growth >=5%
          [%MoM Change] <= -5, -1, // Red if drop <= -5%
          0                        // Otherwise Yellow
      )

      ✅ Then:

      • Put %MoM Change into KPI Indicator Value.

      • Put KPI Indicator Index into KPI Indicator Index.

        Now you should see the arrows with color properly!

        ---

         

@Rajiv_V