Reply
avatar user
Anonymous
Not applicable

Bridge

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

Bridge.jpg

1 REPLY 1
avatar user
Anonymous
Not applicable

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!

Bridge_2.jpg

avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)