Waterfall chart with 3 Measures as Categories and Measures as breakdown.

[MS8590]

I have a requirement where I need to create waterfall as below, where I need to show three total bars (Orange bars), Consider them as A,B and C and consider the Breakdowns as 1,2,3,4 and 5. All of them are measures, B=A+1+2+3 and C=B+4+5. IS this feasible in Power BI waterfall? Currently I am not able to show them in one graph, I had breakdown it into 2 separate waterfall charts where, I sm showing A to B in one and B to C in other graph, but visually it not looking good. 

Below is the dax measure used for Value field

Chart (Measure) =

SWITCH(SELECTEDVALUE(WalkStart_1[Order]),1,SWITCH(SELECTEDVALUE('Sorting'[OCF]),

"1",-1*1,

"2",-1*2,

"3",-1*3,A

),2,SWITCH(SELECTEDVALUE('Sorting'[OCF]),

"1",0,

"2",0,

"3",0,

B))

I have created below tables 

WalkStart_1: Used as Category

Sorting OCF: Used as breakdown

[MS8590]

Hi All,

I am still struggling with this,does any one know how this can be achieved in Power BI waterfall.

[MS8590]

Hi Ada, Thanks for your response, to answer your questions Both the tables are not related, I created static tables to use them in my chart and do the sorting. Yes, I am trying to use Measure as category and also Measure as Breakdown.

I am able to achieve this Partially, where I am able to add these categories in two separate charts i.e A to B in one chart and B to C in other chart but my requirement is to have them in a single chart as given in the above chart i.e. A to B with the breakdowns inbetween then B to C with other breakdowns in between.                    

[Anonymous]

Hi @MS8590 ,

Based on the information you have provided, I am not able to understand exactly what you are looking for. You have provided some of the data, is there a relationship between the two tables, what does it mean to use OCF as a breakdown representation, are you trying to use measure as a Category? measure can not be added to a Category.

Providing more detailed information will allow us to better understand your needs and better accomplish your purpose.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Ada Wang}

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