Plotting variance visual irrespective if negative or positive value

[PXJ99]

Hi everyone,

Really need your help with this one. I am trying to plot the variance for the two tabs in the below (Actual/Budget varaince and Budget/Forecast variance). I need to plot so that it will show me variance irrespestive if its a negative or positive number, so in this example it should give me a bargraph in ascending order of -5K, 4K, $3K, -2K and $1K. I have attached the files.

https://www.dropbox.com/scl/fo/jtg20qg2wqucf83ptdgxh/h?dl=0&rlkey=3yoqgmhz8jkfy39dunn7dme9w

Thank you.

[v-zhangti · Accepted solution]

Hi, @PXJ99 

You can try the following methods.

Column:

ABS = ABS([Variance])

Select the State column to sort by ABS column.

Result:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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