Conditional Formatting while drag and drop the column

[KrishnaPrasad23]

Hello,

When we drag and drop the column from tables, the conditional formatting will have to work from the Measures or Column value.

Typically, conditional formatting will work when we make the changes by click the conditional formatting – Background color in the column.  Here, the requirement when we use visual tables, it we just drag and drop the column2, when the price is equal to or more than 170 it should be green and below or equals 100 it should be red. Anywhere between 170 to 100 it’s yellow. 

Please help with this requirement. I tried the switch function, but it’s not changing and manually made me complete when we do conditional formatting from the visual level.

ProductColumn2

Apple	100
Orange	200
Grapes	150
Pineapple	50
Banana	170

Column2 Color =

SWITCH (

    TRUE(),

    SELECTEDVALUE ( 'Table'[Column2] ) < 100, "#FF0000",       -- Red

    SELECTEDVALUE ( 'Table'[Column2]  ) <= 150, "#FFA500",     -- Orange

    "#00B050"                                                    -- Green

)

[cengizhanarslan · Accepted solution]

This is not possible in Power BI. There is no mechanism that automatically applies conditional formatting when a column is dragged into a table visual. The "fx" wiring step in the Format pane is always required, and it is a one-time manual setup per column per visual.

[v-priyankata]

Hi @KrishnaPrasad23 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@cengizhanarslan @ryan_mayu Thanks for the inputs.

I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.

[cengizhanarslan · Accepted solution]

This is not possible in Power BI. There is no mechanism that automatically applies conditional formatting when a column is dragged into a table visual. The "fx" wiring step in the Format pane is always required, and it is a one-time manual setup per column per visual.

[ryan_mayu]

@KrishnaPrasad23 

you can try this

Column2 Color =

VAR v =

    SELECTEDVALUE ( 'Table'[column] )

RETURN

SWITCH (

    TRUE(),

    v <= 100, "#FF0000",   -- Red

    v < 170,  "#FFFF00",   -- Yellow

    "#00B050"              -- Green (>= 170)

)

pls see the attachment below

[KrishnaPrasad23]

Hello @ryan_mayu,
Good day!!!

Thank you for the dax!!!
Once we created the dax we go to conditional formatting and selecting the fields to change the colors of the background. 
Here the requirement is, when we drag the column the color should be available. We dont need to make the background changes by selecting the field. 
can you help on this.

[ryan_mayu]

does that mean you will change the column to other columns?

I think we build the table first, then set up the conditional formatting. If you didn't drag out the column , I don't think we can set up the conditional formatting.

If I misunderstood, pls clarify your requirements and update the expected output.

[KrishnaPrasad23]

hi @ryan_mayu 

 We are creating the table 1st, then we have the column in the table. When we directly drag and drop the data in the table visual, it has to show the conditional formatting color. 
Usually, when we drag and drop into the visual from the column, we will go to conditional formatting and make the changes as per field. Here, directly when we drag and drop the column in the visual, the color must automatically change without changing anything from conditional formatting. Can we able to do with any DAX? 

[ryan_mayu · Accepted solution]

@KrishnaPrasad23 

I don't think you can do that. That's not the correct steps in Powerbi. In Powerbi, 1st drag out the column to the table, 2nd, set the conditional formatting.