Date Month format 1 char but sort in financial year

[icassiem]

Good day,

I have a calendar dimension with FinYear "2025", FinStartofMonth "2024/06/01" , FinMonthNo "1-12", FinMonth = "Jan", FinMonthShort "M"

The FY Range = 2024.06 to 2025.05

Now I have a custom KPI scorecard that I am building with multiple visuals within the KPI.

Due to limited space and equal visual spacing, I am trying to shorten the width of my graphs by changing from FinMonth to FinMonthShort,  but I am having issues applying the sort as I would now have multiple values for one FinMonthShort, as "J" represents Jan, Jun and Jul

Please help?

Regards

[rajendraongole1]

Hi @icassiem - you can create a calculated column in your calendar table that combines FinMonthShort with a unique identifier like the financial year and month number.

FinMonthShortUnique =
[FinMonthShort] & " " & FORMAT([FinStartOfMonth], "YYYY-MM")

Now, select FinMonthShort in the Fields pane.
Under the "Column Tools" tab, choose "Sort by Column" and select FinMonthShortUnique.
This ensures that the short month abbreviation (FinMonthShort) is sorted correctly while accounting for its uniqueness.

THis works, please check

[icassiem]

Thank You @rajendraongole1 

but no luck; it seems that short of "M" or "J" can only have one unque date for sorting

Please any other ideas?

[icassiem]

Hi,

Please Any ideas

i need to get this working but i am stuck

Regards

[Anonymous]

Hi @icassiem ,

Could you please show sample data or pbix file(does not contain sensitive data)? That will help us reproduce the problem and provide solutions.

Best regards,

Mengmeng Li

[icassiem · Accepted solution]

Hi @rajendraongole1 , @Anonymous 

Thank You for your assistance

I found this article did the trick: https://xxlbi.com/blog/single-letter-day-month-names/

Regards