Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
UK06B1
Helper II
Helper II

Waterfall Chart Help

Hello 

 

I am looking to replicate a waterfall chart in power BI, it is posisble in Excel. Bascially to make the 2 columns in this visual as totals. In excel you can mark them up as Total columns, but the option is not available in POwer BI? 

 

Is this possible, or is there a way using measures or any other way to achieve the same result ? 

 

Thanks

Neil 

 

UK06B1_0-1709130959452.png

 

2 ACCEPTED SOLUTIONS
v-xinruzhu-msft
Community Support
Community Support

Hi @UK06B1 

You can consider to use custom visual and custom their bar color to implement it.

Download the Ultimate waterfall from store.

vxinruzhumsft_0-1709187882370.png

Then put the related field to the visual

Sample data 

vxinruzhumsft_1-1709187922505.png

 

vxinruzhumsft_2-1709187960650.png

 

Then set the bar color at format , e.g  we can set the total to 'grey' ,

vxinruzhumsft_3-1709188065058.png

 

Output

vxinruzhumsft_5-1709188284247.png

 

 

Best Regards!

Yolo Zhu

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

Hi , thanks that works great. I also used the define pillars selection to switch on the total as in the screen shot here . Thanks again for your help. 

UK06B1_0-1709193805688.png

 

View solution in original post

2 REPLIES 2
v-xinruzhu-msft
Community Support
Community Support

Hi @UK06B1 

You can consider to use custom visual and custom their bar color to implement it.

Download the Ultimate waterfall from store.

vxinruzhumsft_0-1709187882370.png

Then put the related field to the visual

Sample data 

vxinruzhumsft_1-1709187922505.png

 

vxinruzhumsft_2-1709187960650.png

 

Then set the bar color at format , e.g  we can set the total to 'grey' ,

vxinruzhumsft_3-1709188065058.png

 

Output

vxinruzhumsft_5-1709188284247.png

 

 

Best Regards!

Yolo Zhu

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

 

 

Hi , thanks that works great. I also used the define pillars selection to switch on the total as in the screen shot here . Thanks again for your help. 

UK06B1_0-1709193805688.png

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.