Forum Discussion
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...
You can format each in the new measure. Please check the file again.
ALLUREAN
Solution Sage
Solution SageYou can format each in the new measure. Please check the file again.
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
)