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 category (gmva comp. in the table below)
This is the table that represents the start and the end of the waterfall and the category that I want to present.
In another table I already calculate all the measures like LY GM, CY GM, production, etc.
now I need to build the waterfall chart.
How am I writhing the commend that each component 1-8 above will present the correct measure in the waterfall chart?
2 Replies
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
