Forum Discussion

goyasor's avatar
goyasor
Frequent Visitor
9 years ago

Waterfall variation by sales type

Hi,   I'm trying to create a waterfall that shows: First Bar:  2015 total Middle Bars:  Year over Year Change End Bar:  2016 Total    For example: First Bar:  2015 total  = 20M Cars Middle B...
Need Help
Tips and Tricks
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

goyasor

 

Hi, One Way to obtain this :

 

Create a New Table (Modeling Menu)

 

Table =
UNION (
    SUMMARIZECOLUMNS (
        Table1[Manufacturer],
        "Variation", SUM ( Table1[2016 Sales] ) - SUM ( Table1[2015 Sales] )
    ),
    ROW ( "Manufacturer,; "2015 Sales", "Variation", SUM ( Table1[2015 Sales] ) )
)

After That, Use the Waterfall Chart with the fields of the new table

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hello Vvelarde could you share the pbix template? im trying to simulate what you did because this solution will help me to extrapolate it to another problem that I have, but I'm getting errors in the formula.

 

 

 

Table =
UNION (
    SUMMARIZECOLUMNS (
        Table1[Manufacturer],
        "Variation", SUM ( Table1[2016 Sales] ) - SUM ( Table1[2015 Sales] )
    ),
    ROW ( "Manufacturer,; "2015 Sales", "Variation", SUM ( Table1[2015 Sales] ) )
)