Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please try below steps:
    1.Create a month table, and add a index column , then sort the month column by index

    Month_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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

Please try below steps:
1.Create a month table, and add a index column , then sort the month column by index

Month_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.