Forum Discussion

lotus22's avatar
lotus22
Icon for Helper III rankHelper III
2 years ago
Solved

How to show % increase on a Bar Chart?

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).

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.