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

JoaoMachado's avatar
JoaoMachado
Advocate I
9 years ago

v-qiuyu-msft

 

Hi, Qiuyun Yu! First of all, thank you for the explanation. I'm having trouble aggregating columns which were already created in Power BI Desktop (they're not present on my excel data base, as I'm not its owner). Is there a way I can do it with the aforementioned columns?

 

Best regards,

João Machado