Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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,...
Need Help
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    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:

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

Well, nothing happens.

I have

Format style: Field value

Apply To: Values only

What field: Delta

_AAndrade's avatar
_AAndrade
Icon for Resident Rockstar rankResident Rockstar
2 years ago

You need to choose What field: Delta Color (the new measure)

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

    The formatting is working fine showing correct values either in red or green.

    However, when I publish my report on the BI Server, all my values show as red (tables and cards)!

    Any idea why? We have BI server Jan 2023.

    Thx. 
    LD