Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Bridge
12-07-2023
07:06 AM
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
1 REPLY 1

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-07-2023
07:40 AM
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!

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
07-14-2025 07:05 AM | |||
07-26-2017 03:10 PM | |||
04-02-2025 02:17 AM | |||
04-01-2025 08:15 AM | |||
08-01-2024 01:20 PM |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |