Forum Discussion

zervino's avatar
zervino
Helper I
2 years ago
Solved

Waterfall chart changes between two years

I have information in this format:   Year Department Sales 2022 Accessories 1200 2022 Services 500 2022 Core 4200 2023 Accessories 800 2023 Services 700 2023 Core ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, zervino 

     

    Based on your information, I create a table:

     

     

    Then follow this steps:

    Create a waterfall visual, and put parameters in the field like this

     

    The first column is the total for 2022 and then a waterfall (increase/decrease) by department and lastly a 2023 total column

     

     

     

    How to Get Your Question Answered Quickly 

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

    Best Regards

    Yongkang Hua

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