Bar Graph, Conditional Formatting, Can I define rule base on another column's value.

[New_Folder]

I have a table similar to below with more than 50 rows. How can I create a graph and define the bars' color base on their team? 

Name	Score	Team
Mike	10	Red
Leni	8	Red
June	9	Red
Jade	3	Yellow
Cris	7	Yellow
Amy	8	Yellow
Chuck	7	Yellow

[v-xiaotang · Accepted solution]

Hi @New_Folder 

Thanks for reaching out to us.

>> define the bars' color base on their team

You can try this measure

color = MIN('Table'[Team])

Setting

result

For more information about conditional formatting, please read Apply conditional table formatting in Power BI - Power BI | Microsoft Docs

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.