Forum Discussion

superglenntot's avatar
superglenntot
Advocate I
9 years ago
Solved

Bar Chart Conditional Formatting

Hi Experts,   Is there any way to change bar color in clustered column chart in Power BI? i.e. If second value is < first value in clustered column chart then change second bar color to red, other...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi superglenntot,

     

    Power BI doesn't provide a feature for us to specify chart column color based on a condition. For your requirement, you can work around the issue utilize the Legend property.

     

    Assume the condition is each amount is less than the previous amount, highlight the current bar with red, otherwise it's green. You can use DAX to transform data firstly. See attached .pbix file.

     

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi superglenntot,

 

Power BI doesn't provide a feature for us to specify chart column color based on a condition. For your requirement, you can work around the issue utilize the Legend property.

 

Assume the condition is each amount is less than the previous amount, highlight the current bar with red, otherwise it's green. You can use DAX to transform data firstly. See attached .pbix file.

 

 

Best Regards,
Qiuyun Yu

Saimadhav007's avatar
Saimadhav007
Regular Visitor
3 years ago

How can i achieve this in measure