Hi,
I'm creating column chart in power bi and want apply conditional formating on both bars profits and Sales.
Like if Profit>=3000 then Green, Profit>=1000 then Amber, Profit <1000= Red
Like if Sales>=4000 then Green, Sales>=3000 then Amber, Sales<1500= Red.
There is no option on column formating tab.
Please help me on this.
2 ACCEPTED SOLUTIONS
Conditional formatting is not supported by multiple columns in the category.
It is also not effective in terms of data visualization.
Beyond that, it is difficult to compare anything beyond each pair individually,
We burden the user with another type of decoding by using conditional formatting that allows both sales and profit to appear in the same color.
Alternatively, you can use the table graph in the picture, which allows you to compare cities, compare sales and profits, and alert you to the circle's values that you need.
There are quite a few steps in creating, so I am attaching a link where you can download the file and follow my steps.
Link to a sample file
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Conditional formatting is not supported by multiple columns in the category.
It is also not effective in terms of data visualization.
Beyond that, it is difficult to compare anything beyond each pair individually,
We burden the user with another type of decoding by using conditional formatting that allows both sales and profit to appear in the same color.
Alternatively, you can use the table graph in the picture, which allows you to compare cities, compare sales and profits, and alert you to the circle's values that you need.
There are quite a few steps in creating, so I am attaching a link where you can download the file and follow my steps.
Link to a sample file
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
