Forum Discussion

New_Folder's avatar
New_Folder
Icon for Helper I rankHelper I
4 years ago
Solved

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...
Need Help
Tutorial Requests
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    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.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

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.