Conditional formatting to reflect only in one measure inside switch

[Anonymous]

i have a table with different measure using a switch formula. I need to show the conditional formatting only for one measure under the switch. when i say conditional its a color coding based on the number. Is there any option to create conditional formatting for measure under switch measure

Example :-

SlicerSelection = VAR Selection = SELECTEDVALUE ( 'Selection Table'[Selection] ) RETURN SWITCH ( TRUE (), Selection = "Domestic", [Domestic], Selection = "International", [International], CALCULATE ( SUM ( 'financials'[Profit] ) ) )

under this measure i want to only color code the financial profit based on number like -0, red between 0-5 yellow above 5 green. Please suggest

[v-easonf-msft · Accepted solution]

Hi， @Anonymous 

You can add a measure like:

Color = SWITCH(TRUE(),[SlicerSelection]<=0,"red",[SlicerSelection]>0&&[SlicerSelection]<=5,"yellow",[SlicerSelection]>5,"green")

Then apply it to conditional formatting of  field background color:

Reltead tutorial:

Apply conditional formatting in tables and matrixes 

Best Regards,
Community Support Team _ Eason

[Greg_Deckler]

@Anonymous Have a look at this:

Min/Max Color Formatter - Microsoft Power BI Community