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
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!
