Changing the color of bars with conditional formatting

[Syndicate_Admin]

Good day community,

I had applied a conditional formatting to a bar chart so that it changed if it was A or AA then the color green was placed, if B or BB changed to yellow... With the installation of the latest version it doesn't let me do this conditional formatting with text-like values

Is there a way to put a conditional formatting back in for text

[Syndicate_Admin]

Hi @WilliamForero ,

Please create a new measure like:

Measure = 
VAR _cur_col_name = SELECTEDVALUE('Table'[Column1])
RETURN
SWITCH(
    TRUE(),
    _cur_col_name IN {"A","AA"},"Green",
    _cur_col_name IN {"B","BB"},"Yellow",
    _cur_col_name IN {"C","CC"},"Orange"
)

and apply it by field value:

Please check the pbix file.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

[Syndicate_Admin]

This is what you tell me is what I need, however, when I try to choose the column of the table that I need to define the criteria, it is not selected.

[Anonymous · Accepted solution]

Hi WilliamForero,

Please create a new measure like:

Measure = 
VAR _cur_col_name = SELECTEDVALUE('Table'[Column1])
RETURN
SWITCH(
    TRUE(),
    _cur_col_name IN {"A","AA"},"Green",
    _cur_col_name IN {"B","BB"},"Yellow",
    _cur_col_name IN {"C","CC"},"Orange"
)

and apply it by field value:

Please check the pbix file.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Anonymous]

Hi @WilliamForero

Try setting it up this way.

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Syndicate_Admin]

hi, @WilliamForero

try to make measure with all condition which you make in your column

[Syndicate_Admin]

I don't understand, what should I do

[Syndicate_Admin]

Could you tell me how it applies

I try to choose the MRC column but it won't let me

[Dangar332]

hI, @Syndicate_Admin 

try to make measure instead of column and then select

[Dangar332]

hi, @Syndicate_Admin 

use color code instead of color text