title: PowerBI - Week Number on X-Axis
body: <p>I have a line graph in PowerBI and in my date dimension I have the Week Number for every date (note that this is a custom week number with the week starting on Friday).</p>
  
  <p>Whenever I put it on a the x-axis, PowerBI groups all the weeks together, regarless of year... so Week 1 of year 2015 will be grouped together with Week 1 of 2016... </p>
  
  <p>I think to myself: "Ok, no problem, I'll just add the Year after every week number so I'll have 1-2016, 2-2016, and so on."</p>
  
  <p>Well PowerBI sees this concatenation as a string value so when I put that on the graph, it goes </p>
  
  <p>1-2016, 1-2017, 2-2016, 2-2017, 3-2016, 4-2016, and so on....</p>
  
  <p>I've tried sorting the new column by the old week number column, but it does the same thing. Any suggestions on how to accomplish this?</p>