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

[am_0106]

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

[v-eachen-msft]

Hi @am_0106 ,

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" )

[am_0106]

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.

[jdbuchanan71]

@am_0106 

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.

[am_0106]

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. 

[jdbuchanan71]

In your example can you tell me what is a column in a table and what is a measure?

[am_0106]

Hi,

Since i am using a live connection with SSAS MD cube, I had created these as calculated columns and created a new DSV to import it in Power BI.

 Thanks Ayush 

[jdbuchanan71]

Can you show me a picture of the table where these are coming from?