Water fall chart breakdown feature.

[Atadapatri]

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.

[v-xuding-msft]

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]

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