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

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
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