Forum Discussion

Atadapatri's avatar
Atadapatri
Regular Visitor
7 years ago

Water fall chart breakdown feature.

Hi Community,

 

I am having a problem in building waterfall chart with a breakdown option or subtotal , I can build the same waterfall chart in Excel 

attaching a screenshot and an excel file.

 

Thanks in Advance.

2 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    7 years ago

    Hi Atadapatri ,

    By my test, you can add a index column and sort by it.

    • Add Column -- > Index Column from 1 -- > Close & Apply  (In Power Query)

    • Choose the column -- >Sort by Column of Index 

    Best Regards,

    Xue

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

    • Atadapatri's avatar
      Atadapatri
      Regular Visitor
      7 years ago

      Thank you for your reply, But I am totally looking for SUBTOTALs