Waterfall Chart or similar..... (excel - powerbi)

[JosePowerbi]

I have a table with category/subcategory labels and values.

When I make a waterfall chart in Excel and in Power Bi the result is similar.

But in excel I have the option to select the columns of the categories and set them as Total, (example Category B, Category C and Category D) with which the graph is as follows...

Waterfall final chart .

It is possible to make this chart in powerbi or similar??

Thanks in advanced.

[JosePowerbi]

Hi Daveus.

I have an index column in the table and the data is sorted.
But what I need is that some categories... (Category A, B, C and D.) start on the X axis at value 0.

I attach the file pbix.

Waterfall.pbix 

https://drive.google.com/file/d/1LMuEIGee50agWGufQytPmMv9YYoMtWuK/view

[v-chenwuz-msft · Accepted solution]

Hi @JosePowerbi ,

Maybe you can try another visual name Simple waterfall.

Best Regards

Community Support Team _ chenwu zhu

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

[davehus]

Hi @, You could add an index column in powerquery and use this to sort the data in visual using sort colum by other value.