Order Clustered Bar Chart

[EloiseS]

Hello,

I have a clustered bar chart which shows Actual Vs Budget per customer. 

Is there a way to order the bar chart based on the difference between Actual and Budget? For example if Customer C's Budget is £500 but their actual is only £100, this should appear ahead of Customer A on the chart who's budget is £700 and their actual is £650.

If this is at all possible, I'd be grateful for any advice. If I need to upload test data please let me know.

Thanks 🙂

[Anonymous · Accepted solution]

Hi @EloiseS ,

The easiest way to do this is to create the columns you want to give calculations to, figure out the difference between budget and actual, and then add the newly created columns to the y-axis of the clustered bar chart as well, and sort them in ascending order.

differ = CustomerData[Actual] - CustomerData[Budget]

Then in the visual settings on the right side, find the corresponding bars and change the color of the bar chart to white or set its transparency to achieve the effect of hiding.

Best Regards,
Adamk Kong

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