Forum Discussion

flavourabbit's avatar
flavourabbit
Frequent Visitor
8 years ago

Waterfall Chart using multiple measures

Hello,   I know this must've been an old topic in Business Intelligence. However, I didn't find any idea to realize what I'd like to achieve.   The thing is I'd like to create a Waterfall Chart ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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!

Zack92's avatar
Zack92
Helper III
3 years ago

Anonymous Hi, I know this is really old. Do you have the sample pbix file? I am not following the. Create a table with matching "measure" name. Thank you