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 table with more than one year, therefore I believe that might be the problem.
Could you please advice?
Thanks
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.
8 Replies
lukiz84Memorable Member
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".
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.- lukiz84
Can you show me your date table after adding the DateSortColumn?
- lukiz84
whats the second one? the first is correct and should work, i use the exact same setting in my date table... so it's weird