Change sort order in a slicer

[mj2024]

Hi

I have a slicer that selects which data series to plot.  The order of the data series in the slicer is not in an order I like:

It should read Relative 20 then Relative 50 then Relative 100.  Here is the measure:

Relative Data Selector = 
DATATABLE(
"DataSource", STRING,
{
{"Relative 20"},
{"Relative 50"},
{"Relative 100"}
}
)

The order in the measure is correct but the slicer is sorting it in a way I don't like.  Is there a way for the slicer to follow the order I am looking for?

Thank you

[Jihwan_Kim · Accepted solution]

Hi,

One of ways is to create a sort column, something like below, and then select the DataSource column, and sort it by the sort-column.

Please check the below picture and the attached pbix file.

DATATABLE function - DAX | Microsoft Learn

Relative Data Selector =
DATATABLE (
    "DataSource", STRING,
    "Sort", INTEGER,
    {
        { "Relative 20", 1 },
        { "Relative 50", 2 },
        { "Relative 100", 3 }
    }
)

[mj2024]

Thank you @Jihwan_Kim .  It works!