Forum Discussion

Andres_Maldo's avatar
Andres_Maldo
Frequent Visitor
4 years ago
Solved

Grouping measures in a matrix

Hi, Guys. I have 4 measures (ROI, EBITDA, KPI 1, KPI 2) and I would like to classify in groups:   FINANCE: ROI, EBITDA SALES: KPI 1, KPI 2   And I woud like to get this matrix: I appreci...
Andres_Maldo's avatar
Andres_Maldo
Frequent Visitor
4 years ago

Thanks, I see. That´s an interesting approach, but what if I want KPI1 as a decimal number, KPI2 as a whole number and ROI as a percentaje? And I want to use conditional formatting in just one measure?

  • Andres_Maldo's avatar
    Andres_Maldo
    Frequent Visitor
    4 years ago

    Hi, ALLUREAN.

    I used a similar dax for colors, and it worked for conditional formatting.

     

    Colors =
    VAR Selected = SELECTEDVALUE(HeaderTable[Level2])
    var x = IF(HeaderTable[ROI] > 0.10, "#A0D1FF")
    var y = IF(HeaderTable[KPI1] > 30, "green", "red")
    RETURN
    SWITCH(TRUE(),
    Selected = "ROI", x,
    Selected = "KPI1", y
    )
  • Andres_Maldo's avatar
    Andres_Maldo
    Frequent Visitor
    4 years ago

    Thanks, and I would like to use different conditional formating for each measure, for example, KP1 is going to be red if it is greater than 30 and green if it is lower than 30. But ROI is going to be green if it is greater than 10% and red if is lower than 10%.