POWER KPI MATRIX 3.1.1.

[lucasv]

Hello,

I am having issues with the POWER KPI MATRIX 3.1.1. were i want to display 3 diferent calculated measures as Row-based Metric Name("M USD", "Ton" & "USD Ton") in one Category named "Process"(it has more than 10 different) with each calculated measure has is own actual & comparison values.

I want to replicate this image in to the POWER KPI MATRIX 3.1.1:

Thanks in advanced for the help.

 

@amitchandak, @Greg_Deckler , @parry2k 

 

[v-shex-msft · Accepted solution]

Hi @lucasv,

Perhaps you can consider creating a new navigation measure with selectedvalue and switch functions.

For this scenario, you can use the switch to navigate to different measure calculations based on the current category value.

Reference links:

My Favorite DAX Feature: SELECTEDVALUE with SWITCH | Winston-Salem Power BI User Group (pbiusergroup...

Change the Column or Measure Value in a Power BI Visual by Selection of the Slicer: Parameter Table ...

Regards,

Xiaoxin Sheng