cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors