Chart Variance-ERROR BAR please help

Hi

Please see the attached file below. Basically I want to achieve the image of the chart below in my file with the error bars. In my file, Instead of years, I have a month column and aban rate column(dummy file). What I want the pivot chart to do is in the following steps below and would appreciate your help in achieving it:

1. give the variance from current to the next month in power query or power pivot so it is automated
2. if for example the aban rate is 25% in January and 30% in February than I want it to give a red arrow with variance. Else, if the aban rate is 25% in January and goes down to 20% in February then I want it to show a green with a positive variance.
3. every month new month data will be appended each month so don't want format to lose as well.


The image below is just an example of the error bars that I want to show on my chart in the file attached with my data in pivot table.

Captur9.PNG

There are 5 helper columns with many steps.
4 clusters column, with 2 clusters on the secondary axis and error bars.

Custom format Error minus % to -0%

Hi,

Thank you so much! Can you please see my questions below:

1. Every month the data will have a new month appended to the pivot table so can you please show me how to automate this in power pivot with formulas or power query? I would really appreciate...that is where I need help so populates automatically at least some part of it.

2.Also, I was wondering how I change it to show if aban rate increases from 25% to 30% it should be red instead of green and if it decreases then it should be green. Can you show me how I flip flop that since in the file you attached its showing the opposite of what i need. Can you please tell me what this formula means below? Kinda confused with the formula

Captur10.PNG

3. For example below, the chart for Jan 2020 shows, a dark blue(jan20) and light blue(feb20)-is there a way since we already have Feb20 dark blue can the arrow show it towards that and remove the light blue bars to avoid confusion?

Capture11.PNG

This requires POWER PIVOT with DAX measure and many steps. but the concept is the same as formula.

Thank you so much for all your help! I can't appreciate you enough. The file is basically what I want but with few tweaks. This will be the hopefully the last questions. I have 2 questions below after putting it in my actual data:

Question 1. My month column looks like this in the second image below in my actual data source but if you see the first image after entering the next rate formula i'm getting an error saying "Calculation error in measure, Function 'DATEADD' only works with contigous date selections". How do i fix that?

first image
Capture11.PNG

second image
Capture10.PNG

Question 2. If you see the image below, can you help me achieve this by changing the formula that you provided. for example: if in Jan20 the "total rate" column is 25% and Feb20 it is 30% then I want the variance and arrow to show RED and not green. And if for Feb20 is 30% and Mar20 is 19% then I want it to show GREEN arrow with a a positve variance that it is getting better.

Capture12.PNG