Waterfall Chart using multiple measures

Hi,

Yes, you can do it via a workaround in DAX formula and a control table.

1. Create a table with matching "measure" name:

2. Create an additional measure for your waterfall chart, you may apply + or - for your measure to get the waterfall sentiment:

Waterfall value = 
    SWITCH (
        SELECTEDVALUE ( Table1[Index] );
        1; +[Measure 1];
        2; +[Measure 2];
        3; -[Measure 3];
        BLANK()
    )

3. Apply the new measure in your waterfall chart, with the category based on the table field created (Note that you need to sort it via the category, use hierarchical drill-down if needed):

Cheers!

You can actually create a new table containing the names of your measures (You can write them manually). You can then use this table as your category in your waterfall and create a new measure for your Y axis. My measure looks like ; WF Measures = VAR Meas = SELECTEDVALUE('Waterfall 2'[Column1]) return SWITCH(TRUE(); Meas = "Ending Inventory (LY)" ;1 ;Meas = "Beginning Inventory (Feb)";-1 ; Meas = "Production" ; 1; Meas = "Sales" ; -1;Meas = "Interco & Adjustments *" ;4 ;Meas = "Ending Inventory (Act)" ; 1; -10) **You can replace the numbers with the measure you want it to calculate**

Hi flavourabbit,

"

However, only solution I found at Google is restructuring the dataset like below

I don't think it's a good idea to manipulate the fact table, plus if I create another table, all the current measure refering the Table A would be not working with newly made one.

"

<--- Could you please clarify more details or give a demo about your fact table, Table A, current measures and expected result?

Regards,

Jimmy Tao 

I'm having the exact same issues as well with multiple measures not working in the Waterfall visual. I was hoping that there would have been a solution by now but I guess not :( 

I created a mock up of the data so I could show the database guys what I was trying to achieve and it doesn't look like it's possible without creating a completley new table with the specific purpose of providing this visual - which is probably not going to happen.