Solved: Waterfall Graph Application

JeffreyLau · ‎11-05-2017

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).

Eric_Zhang · ‎11-06-2017

@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).

@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.

View solution in original post

Eric_Zhang · ‎11-06-2017

@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).

@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.