Sorting a slicer

[Sdutta]

Hello all,

In my source table I got 2 date columns.

PeriodCode = 201601, 201602, 201603 ....201612

PeriodName = Oct2016, Nov2016, Dec2016....Sep2017

Where 201601 corresponds to Oct2016 as that's when our company financial year starts.

In the slicer, I want to show PeriodName but sort it by PeriodCode rather than it sorting itself alphabetically. How can I achieve this please?

Thanks much.

[MFelix · Accepted solution]

Hi @Sdutta,

You should sort your column by the PeriodCode and then you will get the information as you want.

Regards,

MFelix

[Sdutta]

Absolutely perfect, thank you so much.

Having worked in SSRS for years, I am just a bit slow in getting used to Power BI way of dealing with these things.

Regards

SDutta