Forum Discussion

Saxon10's avatar
Saxon10
Post Prodigy
4 years ago
Solved

Conditional formatting for Variable

  I have the following columns are Id, Code, Result1, Result2, Result1 colour code and Result colour code in data table.   For Result1 and Resul2 created slicer table for switch the Results in vis...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Define a similar color measure.

    VarColor = 
SWITCH (
    SELECTEDVALUE ( Slicer[Result] ),
    "Result 1", SELECTEDVALUE ( REPORT[Result colour code] ),
    "Result 2", SELECTEDVALUE ( REPORT[Result2 colour code] )
)

     

    Then use that in the conditional formatting.

     

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

Define a similar color measure.

VarColor = 
SWITCH (
    SELECTEDVALUE ( Slicer[Result] ),
    "Result 1", SELECTEDVALUE ( REPORT[Result colour code] ),
    "Result 2", SELECTEDVALUE ( REPORT[Result2 colour code] )
)

 

Then use that in the conditional formatting.

 

  • Saxon10's avatar
    Saxon10
    Post Prodigy
    4 years ago

    Hi. Thanks for your reply and sorry for the late response.

    Your solution is working well.