mrchonginhk
Well-known Member
- Joined
- Dec 3, 2004
- Messages
- 679
I have created a date table and have marked it as date table in Power BI
Apart from date, there is a Month Name column I have created like Jul-18 etc
When I use this MonthName dimension in visuals like Matrix,
Apr become first as it starts with an "A"
So how can we ensure it is ordered by date instead of ordered by name ?
I tried click the MonthName field and then select Sort By Another Column then select Date but it returns an error:
"We can't sort this column by 'Date'. There can't be more than one value in 'Date' for the same value in 'MonthName' "
What can we do ?
Thanks
Apart from date, there is a Month Name column I have created like Jul-18 etc
When I use this MonthName dimension in visuals like Matrix,
Apr become first as it starts with an "A"
So how can we ensure it is ordered by date instead of ordered by name ?
I tried click the MonthName field and then select Sort By Another Column then select Date but it returns an error:
"We can't sort this column by 'Date'. There can't be more than one value in 'Date' for the same value in 'MonthName' "
What can we do ?
Thanks