Forum Discussion
PowerBI sort by Month Number
Hi, I am trying to arrange my central date table by month number in order to have the line graph display January through December but I keep getting a cardinality error. I have a central date...
Hi Anonymous ,
Please try below steps:
1.Create a month table, and add a index column , then sort the month column by indexMonth_sort:
2.Create a relationship between your month table and fact table
Fact:
Mode:
3.Then add a line chart
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Add a DateSortColumn to your Calendar table, like
DateSortColumn := 100 * YEAR(Calendar[Date]) + MONTH(Calendar[Date])
and apply this to your Month-Column as "Sort by".
Thanks for the reply. I am getting this error when I try to sort?