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:

     

     

ChiragGarg2512's avatar
ChiragGarg2512
Icon for Solution Sage rankSolution Sage
2 years ago

Go to Format Visual -> Cell Element -> Background Color -> Field[Format Style] -> Select the measure.

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