Forum Discussion
Bar Graph, Conditional Formatting, Can I define rule base on another column's value.
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 |
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.
1 Reply
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.