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
Anonymous
Not applicable

Craete waterfall chart

waterfall.jpg

 

Dear 

is there a way to craete a waterfall chart like this.

Regards,

 

 

1 ACCEPTED SOLUTION
v-yingjl
Community Support
Community Support

Hi @Anonymous ,

As we know,  waterfall charts show a running total as Power BI adds and subtracts values. They're useful for understanding how an initial value (like net income) is affected by a series of positive and negative changes.

In my opinion, the most waterfall charts I have tested in power bi desktop may not match your expected output for this case because waterfall chart cannot show the column value and the line value at the same time.

What I suggested is that you can try a combo chart like Line and stacked column chart to meet part of your requirement:

  1. You can enable Data Labels to show data values
  2. You can enable Show maker under Shapes lab and set the maker shapes

line and column chart.png

 

For further information about waterfall chart and combo chart, you can refer the following Microsoft documents that could help you:

  1. https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-waterfall-charts
  2. https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

 

Best Regards,

Yingjie Li

 

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

3 REPLIES 3
v-yingjl
Community Support
Community Support

Hi @Anonymous ,

As we know,  waterfall charts show a running total as Power BI adds and subtracts values. They're useful for understanding how an initial value (like net income) is affected by a series of positive and negative changes.

In my opinion, the most waterfall charts I have tested in power bi desktop may not match your expected output for this case because waterfall chart cannot show the column value and the line value at the same time.

What I suggested is that you can try a combo chart like Line and stacked column chart to meet part of your requirement:

  1. You can enable Data Labels to show data values
  2. You can enable Show maker under Shapes lab and set the maker shapes

line and column chart.png

 

For further information about waterfall chart and combo chart, you can refer the following Microsoft documents that could help you:

  1. https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-waterfall-charts
  2. https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

 

Best Regards,

Yingjie Li

 

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

amitchandak
Super User
Super User

You need to check some custom charts. But Is this chart known and waterfall. I am assuming you are taking with horizontal bar and line

 

Anonymous
Not applicable

Dear @amitchandak 

Thank you for reply ,

I don't know exactly what the name is  🤣 , but I need to know how can I create one like it .

Regards,

 

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.