Forum Discussion
Conditional formatting
Hi, I have a measure Delta as follow: Delta = SWITCH( TRUE(), [Hours_Submitted_TS] - [Hours_Forecast] > 0, "Charged more than expected", [Hours_Submitted_TS] - [Hours_Forecast] < 0,...
Hi Anonymous,
You can use a measure to define the color like this:
Delta Color= SWITCH(TRUE(),[Delta ] = "Charged more than expected", "RED",[Delta ] = "Charged less than expected", "YELLOW",[Delta ] = "Charged as forecasted", "GREEN")
Then go to Format Ribon and follow the path indicated by ChiragGarg2512., like this:
_AAndrade
Resident Rockstar
Resident RockstarHi Anonymous,
You can use a measure to define the color like this:
Delta Color= SWITCH(
TRUE(),
[Delta ] = "Charged more than expected", "RED",
[Delta ] = "Charged less than expected", "YELLOW",
[Delta ] = "Charged as forecasted", "GREEN"
)
Then go to Format Ribon and follow the path indicated by ChiragGarg2512., like this:
Then go to Format Ribon and follow the path indicated by ChiragGarg2512., like this:
ChiragGarg2512Solution Sage
_AAndrade Thanks for the correction.