cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tusozor Helper I
Helper I

Waterfall - Not calculated total

Hello,

 

I've just received a weird need from my business and I have no idea to handle it.

 

They want to display a waterfall chart but both categories and total should comes from the data. Therefore the Total is not calculated by Power BI.

 

Below it's an example of the need. In the data the "Category 1...12" and the Total is the same field. But they want to get the Total in the different shape than the other results.

 

Is existing a way to do this ?

 

Thank you.  

 

WATERFALL.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Waterfall - Not calculated total

hi, @Tusozor

Is your data structure like this?

1.PNG

If so, I'm afraid it couldn't achieve in Power BI for now. you may try to set visual level filter to filter column1 total data

2.PNG

 

and if you want to get the Total in the different shape than the other results

You may try to drag the total into a different visual, like Pie chart

 

For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner .

 

 

 

Best Regards,

Lin

 

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

View solution in original post

2 REPLIES 2
Community Support
Community Support

Re: Waterfall - Not calculated total

hi, @Tusozor

Is your data structure like this?

1.PNG

If so, I'm afraid it couldn't achieve in Power BI for now. you may try to set visual level filter to filter column1 total data

2.PNG

 

and if you want to get the Total in the different shape than the other results

You may try to drag the total into a different visual, like Pie chart

 

For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner .

 

 

 

Best Regards,

Lin

 

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

View solution in original post

Tusozor Helper I
Helper I

Re: Waterfall - Not calculated total

Hello @v-lili6-msft,

 

Thank you for your answer !

 

Yes my data structure is like this. Unfortunately I came out with the same conclusion as you !

 

I will try the Ideas 🙂

 

Thank you again !

 

Kind regards.

 

Tus

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors