cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## Conditional formating using a Measure

Hi!

I created a measure to be used in a Matrix usinf the bellow code:

``````Measure 2 = IF (
ISINSCOPE('Table[nm_mdld]),
VAR indx = DIVIDE(SUM('Table'[vl_pe]), sum('Table'[vl_pvs]), 1)-1
VAR grade = SWITCH(TRUE, indx <= 0.01, "1",
indx > 0.01 && indx <= 0.05, "2",
indx > 0.05 && indx <= 0.10, "3",
indx > 0.10 && indx <= 0.20, "4",
indx > 0.20, "5")
VAR indx = DIVIDE(SUM('Table'[vl_pe]), sum('Table'[vl_pvs]), 1)-1
VAR grade = SWITCH(TRUE, indx <= 0.01, "1",
indx > 0.01 && indx <= 0.05, "2",
indx > 0.05 && indx <= 0.10, "3",
indx > 0.10 && indx <= 0.20, "4",
indx > 0.20, "5")
)``````

I would like to use the value in the Measure 2 e.g. (1,2,3,4,5) to change it´s cell color, but I was unable to find a solution. I´m newbe in DAX .

Regards.

Super User

instead of returning "1"  you can return the name of the color.

``````Measure 2 = IF (
ISINSCOPE('Table[nm_mdld]),
VAR indx = DIVIDE(SUM('Table'[vl_pe]), sum('Table'[vl_pvs]), 1)-1
return SWITCH(TRUE, indx <= 0.01, "red",
indx <= 0.05, "pink",
indx <= 0.10, "yellow",
indx <= 0.20, "orange",
"green")
)``````

and then color by "field value".

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors