Month Sort Working in Table but not in Card

[Anonymous]

Good afternoon everyone, 

Hoping to get a little help here. As the title states, my month sort works perfectly fine in a Table, but is defaulting back to alphabetical in Card view. I am working on a custom KPI scorecard and need to be able to put the most recent month's value in a card. 

Month Name = SWITCH(Table_9572[Month], 1, "Jan", 2, "Feb", 3, "Mar", 4, "Apr", 5, "May", 6, "Jun", 7, "Jul", 8, "Aug", 9, "Sep", 10, "Oct", 11, "Nov", 12, "Dec")

Month Name is being sorted by the column "Month" and has worked as desired in the other report pages

Month = MONTH(Table_9572[RO Date Invoiced])

 

   Table                                            Card

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

From your scenario, the card visual is sorted by unicode for text in power bi:

If you want to show Dec in card, you could refer to below measure:

Last Month name = CALCULATE(MAX('Table1'[Month Name]),FILTER('Table1','Table1'[Month]=MAXX('Table1','Table1'[Month])))

Result:

Regards,

Daniel He

[Anonymous]

Worked perfectly. Thank you so much!!!

[parry2k]

@Anonymous I believe at the aggregate function it doesn't use "sort by column". You can achieve the last month name by wiritng specific dax measure