Power KPI Matrix

Rajiv_V — Fri, 11 Apr 2025 09:14:37 GMT

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.

Re: Power KPI Matrix

johnbasha33 — Fri, 18 Apr 2025 13:58:50 GMT

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

topic Power KPI Matrix in Custom Visuals Development Discussion

Power KPI Matrix

Re: Power KPI Matrix

1. Page navigation links within Power KPI Matrix rows

2. About KPI Indicator Value and KPI Indicator Index

✨ Example to make your Indicators work: