How to show % increase on a Bar Chart?

[lotus22]

Team, any support is helpful. How can I show a percentage increase with multiple charts on the same value on the X-axis? I have not shown the X-axis. Basically, it has a supplier, and each supplier has a growth rate of multiple years. Four graphs show Years W, X, Y, and Z for supplier A. The growth from 3.8 to 5.1 is 33%. It is always between the first year and the last year (W and Z in this case).

[Anonymous · Accepted solution]

Hi @lotus22 ,

I'm not sure I'm understanding you correctly. I think you are trying to show these three percentage numbers in this chart?
But it's unlikely that you'll be able to implement this format in this visual object:

I recommend that you use this visual object:

And use this DAX to create a measure:

Measure = 
VAR _maxyear =
CALCULATE(
    MAX('Table'[Year]),
    ALL('Table')
)
VAR _minyear =
CALCULATE(
    MIN('Table'[Year]),
    ALL('Table')
)
VAR _max = 
CALCULATE(
    SUM('Table'[Value]),
    ALLEXCEPT('Table', 'Table'[Type]),
    'Table'[Year] = _maxyear
)
VAR _min = 
CALCULATE(
    SUM('Table'[Value]),
    ALLEXCEPT('Table', 'Table'[Type]),
    'Table'[Year] = 
    _minyear
)
RETURN
(_max - _min) / _min

Create the visual and the final output is as below (I changed the font color of the data labels for clarity) :

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