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.
I tried the correct one and it is still giving the same error 😞
I have multiple years, could this be the issue?
no, that's the default case ... can you send the pbx file?