Charticulator Bar Chart not sorting correctly

[eglissen]

Hi,

I am trying to apply custom sorting on a clustered bar chart, created in Charticulator.

We have Geography dimension (Country names) in y axis and two measures in X axis – amount of Sales A and amount of Sales B.

The requirement is that the chart would always be sorted descending by Sales B amount (simplified version of the visual as below).

These are the settings I use in Charticulator.

We have a slicer that is modifying Geography dimension.

The sorting is working well when the Geography slicer is set to the same selection as when the Charticulator chart was saved. However, when the Geography slicer selection is changed, i.e. other countries are selected, sorting is reset back to order by “Geography” (see example below).

Is there a way to ensure that the same sorting logic is applied even when y axis is adjusted based on slicer input?

Thanks in advance for any advice!

[v-chenwuz-msft · Accepted solution]

Hi @eglissen ,

Please create a measure to rank them in all the table.

Measure:

Measure =
RANKX (
    CALCULATETABLE (
        VALUES ( global_resource_trade_links[Region] ),
        ALLSELECTED ( global_resource_trade_links )
    ),
    CALCULATE ( SUM ( global_resource_trade_links[Amount] ) ),
    ,
    DESC
)

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ronaldbalza2023]

Hi @eglissen , hope you are having a great day. Please see this link that may help you solving this.
Using in Power BI | Charticulator