Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to do conditional formatting having different rules for the same column

Hi,   I am trying  to attach conditional formatting for one of the columns in my report. Now I have different set of rules for different rows of the same column. Is there a way to add different set...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

You could create a measure to set different rules of conditional formatting by IF() or SWITCH() functions. Like the following DAX:

measure =
IF ( SELECTEDVALUE ( 'Table'[Column] ) > 0, "#00FF00", "#EE00CC" )

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    This means I have to define a new measure in the cube itself and pull it to the Power BI, that idea did hit me as well but I wanted to see if I can to it in the Power BI itself.