Forum Discussion

g4joe's avatar
g4joe
Frequent Visitor
6 years ago
Solved

Help with displaying week numbers correctly

I've tried to figure this seemingly simple issue out but I can't !     I want to show a line chart values by fiscal week number using the table in the image.  The top chart is how I want to...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    g4joe yes it will but there is no other way, you cannot have following sort order on number, assumg two column year and week number, if you don't year, you cannot have week no. 1 for 2011 come after week no. 4 of 2010 so you have to have some other value to sort it correctly

     

    2010 1

    2010 2

    2010 3

    2010 4

    2011 1

    2011 2

    2011 3

     

     

  • dax's avatar
    dax
    6 years ago

    Hi g4joe , 

    This seems to be by design. So workaround is that as parry2k  mentioned, use year as legend, and use continuous x axis, or use categorical x axis, then create a measure(measure = 12 fixed value) as trend line, add this in Value field.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k's avatar
parry2k
Super User
6 years ago

g4joe week column doesn't have awareness of year, and that's why, you should add a week column with year

 

Week Year = COMBINEVALUES ( ",", Table[Year], Table[Week] )

 

and now use this new column on x-axis

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

g4joe's avatar
g4joe
Frequent Visitor
6 years ago

Hi thanks for the response.

 

Wouldn't that force the x-axis to be categorical - which is not what I want

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    g4joe yes it will but there is no other way, you cannot have following sort order on number, assumg two column year and week number, if you don't year, you cannot have week no. 1 for 2011 come after week no. 4 of 2010 so you have to have some other value to sort it correctly

     

    2010 1

    2010 2

    2010 3

    2010 4

    2011 1

    2011 2

    2011 3

     

     

    • g4joe's avatar
      g4joe
      Frequent Visitor
      6 years ago

      Thanks for your help with this.

       

      It's a pity using categorical axes has a couple of downsides regarding the scroll bars and trend lines.

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi g4joe , 

    This seems to be by design. So workaround is that as parry2k  mentioned, use year as legend, and use continuous x axis, or use categorical x axis, then create a measure(measure = 12 fixed value) as trend line, add this in Value field.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.