Bridge

[Anonymous]

Hello Everybody,

Does anyone know how to sort the different effects on the X axis with the following order : Price, Vol, Mix, Cogs, Non Comp ?

Seems like it's actually done by ascending pr descending values...

Here after my syntax :

PVMC Gross Margin Bud (Bridge) =

SWITCH(SELECTEDVALUE('WTF Period Bud'[Period Order]),

    1,

    SWITCH(SELECTEDVALUE('WTF Price-Vol-Mix-Cogs'[PVMC Order]),

        1, [Rate Effect Bud.]*-1,

        2, [Price Effect Bud.]*-1,

        3, [Vol Effect Bud.]*-1,

        4, [Mix Effect Bud.]*-1,

        5, [COGS Effect Bud.]*-1,

        6, [Non Comp Effect Bud.]*-1,

        [Gross Margin Bud. Y]

    ),

    2,

    SWITCH(SELECTEDVALUE('WTF Price-Vol-Mix-Cogs'[PVMC Order]),

        1, 0,

        2, 0,

        3, 0,

        4, 0,

        5, 0,

        6, 0,

        [Gross Margin Y]

    )

)

Thank you fr your help 😉

Geoffrey

[Anonymous]

Hey guys,

One other thing : When I try to sort my visual by Period Name (BUD to CY), this is what PBI is doing :

A full reversal!