Forum Discussion
Waterfall charts
hello really need some help (I am new here) and I am in a dead end I need to create a waterfall chart to see gm variance from one period (last year) to second period (current year) breakdown by cat...
ron_l100 What does your main data table look like in raw format?
If you want to compare CY to LY for many categories, you should only need to create one measure:
Sales = SUM(Sales[Sales] )
Put GMVA_Comp in the 'breakdown' for the waterfall and DimDate[Year] in the Category and [Sales] in values.
hi
i have another table with all the measures that i want to see in the waterfall chart/ i already calculated everything.
i need an example how to writh the comand that will switch or insert each measure to the waterfall component table . i read that i may use switch comand but i can find how to do that