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!

RicardoPereira's avatar
RicardoPereira
Frequent Visitor
6 years ago

That's prety cool Anonymous, thanks

We dont need the column with the measures name in the table, just one with the names that we want in the axis, sorted by the index column. 
In the graph we only need that name column, and the graph sorted by that column. No need for drilldown

Any ideas on how to change he colors? Maybe with the breakdown field?