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!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi..Thanks for this solution. But how can you remove Total bar?? In my case, total bar is undesirable...moreover, can we change the colour of first and last bars to keep in lookalike?

  • Jcarlos9's avatar
    Jcarlos9
    New Member
    6 years ago

    this is my question!!