Charticulator Bar Chart not sorting correctly

Question

Hi,&nbsp;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).&nbsp;&nbsp;These are the settings I use in Charticulator.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;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).&nbsp;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!&nbsp;&nbsp;&nbsp;

v-chenwuz-msft · Accepted Answer

Hi&nbsp;eglissen&nbsp;,
&nbsp;
Please create a measure to rank them in all the table.

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

&nbsp;
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;

Forum Discussion

Charticulator Bar Chart not sorting correctly

2 Replies

Related content

charticulator

Months Not Sorted Correctly

charticulator's constraints

Sorting

PowerBI Date Fields not Sorting Correctly