Bridge

Anonymous — Thu, 07 Dec 2023 15:06:49 GMT

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]),

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]

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

Re: Bridge

Anonymous — Thu, 07 Dec 2023 15:40:24 GMT

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!