Forum Discussion
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 of rules for conditional formatting in the same column?
I will really appreciate any suggestions.
Kind Regards,
Ayush
7 Replies
Anonymous
Yes, it should be possible. Can you share some sample data and expected results? Please share the sample data in a table format, not a screen shot.
Goals Current Performance Expected Performance Indicator YTD Old Application 1545 1325 116.6 YTD New Application 798 1012 98.7 Avg Days from Application to eligibility 20 30 -10 I want to add conditional formatting on Indicator column where the first two rows have a percentage calculated value and the bottom one is the difference between Second and third columns.
In your example can you tell me what is a column in a table and what is a measure?
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" )
