Latest Enterprise DNA Initiatives

How to make a date hierarchy slicer sort by Year then Month

I have a Fiscal Year hierarchy in my model, with Fiscal Year > Month > Week. However, I can’t make the slicer sort the month items anything other than alphabetically. I have tried setting Fiscal Week to be the sort column, but to no avail… what am I missing? I have attached a sample model by way of demonstration.

FiscalYear.pbix (171.5 KB)

Hello @Jamie,

Thank You for posting your query onto the Forum.

Below is the solution provided for the reference alongwith the screenshot about how you can sort the “Fiscal Month Name” in ascending order which will be in sync with the “Fiscal Week”.

So rather than sorting the “Fiscal Month Name” by “Fiscal Week”. Just select the field “Field Month Name” from the date field and sort it by “FIscal Month Number”.

  1. Result before Sorting -

Result before Sorting

  1. Select “Fiscal Month Name” into the Date table -

Select "Fiscal Month Name" into the Date table

  1. Sort it by “Fiscal Month Number” -

  1. Final Results -

Final Results

I’m also attaching the working of the PBIX file for the reference.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

Fiscal Year - Harsh.pbix (172.0 KB)

Ah - I see! Any column can have a sort by Column, it’s at column level not table level, I had forgotten that (if I ever knew it!)

Many thanks

Jamie