I am building a Power BI Choropleth map using the January 2024 PBI desktop version and would like some assistance setting a custom sort order for the map.

Currently, the sort order for the legend is being shown in the order of distribution but I would like to get it by a specific physical order of data as seen in the sample table, colordistributionmaster.

The data for the issue is available here: DB fiddle

I have used County for the “Locations” field, elignumber for the “values” field and colordistribution for the legend field. The data for this comes from the table, finalchoroplethdata.

I am using default theme colors and no custom data colors are being used here.

I did try joining the tables finalchoroplethdata and colordistributionmaster, using the column, colordistribution, and attaching an index column to sort the data in colordistributionmaster, but it had no effect on the legend sort order.

I did try the option of “Sort a column by other column option” too.

I am expecting the legend to be ordered in this fashion in ascending order:
‘0-99’ ‘100-199’ ‘200-299’ ‘300-399’ ‘400-500’