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.
lukiz84
Memorable Member
Memorable Memberwhats the second one? the first is correct and should work, i use the exact same setting in my date table... so it's weird
I tried the correct one and it is still giving the same error 😞
I have multiple years, could this be the issue?
- lukiz84
no, that's the default case ... can you send the pbx file?