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

So I have tried your DAX two different ways as I couldn't close brackets. I get the same error for both. 

 

 

 

lukiz84's avatar
lukiz84
Memorable Member
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I tried the correct one and it is still giving the same error 😞

    I have multiple years, could this be the issue? 

    • lukiz84's avatar
      lukiz84
      Memorable Member
      4 years ago

      no, that's the default case ... can you send the pbx file?