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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
JeffreyLau
New Member

Waterfall Graph Application

Hi all,

 

From the Tutorial, the waterfall graph can present the changes over time.  But I did something else in excel as below as try to replicate it in Power BI but in vain. 

 

Below, i am showing the breakdown by elements.  For those elements, they are different attributes (fields) in the database.  Not sure how to put the fields into the visualisation panel (Category, Breakdown, Y Axis).

 

 

Capture.PNGCapture2.PNG

 

 

1 ACCEPTED SOLUTION
Eric_Zhang
Microsoft Employee
Microsoft Employee


@JeffreyLau wrote:

Hi all,

 

From the Tutorial, the waterfall graph can present the changes over time.  But I did something else in excel as below as try to replicate it in Power BI but in vain. 

 

Below, i am showing the breakdown by elements.  For those elements, they are different attributes (fields) in the database.  Not sure how to put the fields into the visualisation panel (Category, Breakdown, Y Axis).

 

 

Capture.PNGCapture2.PNG

 

 


@JeffreyLau

AFAIK, it is not able to create the very equivalent waterfall graph in Power BI. One similar graph as below can be created, however the elements have to be assigned an index to determine the present order in the graph. See more details in the attached pbix file.

Capture.PNG

Capture.PNG

View solution in original post

1 REPLY 1
Eric_Zhang
Microsoft Employee
Microsoft Employee


@JeffreyLau wrote:

Hi all,

 

From the Tutorial, the waterfall graph can present the changes over time.  But I did something else in excel as below as try to replicate it in Power BI but in vain. 

 

Below, i am showing the breakdown by elements.  For those elements, they are different attributes (fields) in the database.  Not sure how to put the fields into the visualisation panel (Category, Breakdown, Y Axis).

 

 

Capture.PNGCapture2.PNG

 

 


@JeffreyLau

AFAIK, it is not able to create the very equivalent waterfall graph in Power BI. One similar graph as below can be created, however the elements have to be assigned an index to determine the present order in the graph. See more details in the attached pbix file.

Capture.PNG

Capture.PNG

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.