Forum Discussion
Month Sort Working in Table but not in Card
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
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
3 Replies
v-danhe-msftMicrosoft Employee
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
- parry2k
Super User
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
