Forum Discussion

JuanSombrero's avatar
JuanSombrero
Frequent Visitor
9 years ago
Solved

Waterfall challenge

Hi all,   I am trying to create a waterfall chart, but not through the 'classic' approach. I have data for budget, actual, forecast, estimate,...all of them are in separate data tables in my model,...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi JuanSombrero,

     

    Based on my test, we are not able to use DAX to treat values from many measures in one table column.

     

    In your scenario, you can merge queries as a new query for  budget, actual, forecast, estimate,... Then Group By the Year and Month, return total value for  budget, actual, forecast, estimate.... Then check ActualTotal, BudgetTotal, ForcastTotal columns and click Unpivot columns.

     

     

     

    Best Regards,
    Qiuyun Yu

abhyanka's avatar
abhyanka
New Member
8 years ago

Hi all, 

 

Wondering if there is a way to solve for something similar- except all my data is within one table already. I just wanted to create a waterfall chart with multiple Breakdowns, if this is even possible. I.e. I have 3 different categories that add up to my total, and I want to show the breakout of those over the course of the quarter. 

 

Thanks!