title: Sort Month text (jan, feb etc.) in multiple year dataset
body: <p>In Power BI I need to make a visual with a bar chart showing values over 12 months, from jan to dec. However, my dataset has 3 years of daily data, so I cannot sort by another helper column (monthsort) as there are more distinct values in the sort column than the result column.</p>
  
  <p>How can I get an x-axis sorted from jan to dec?</p>
  
  <p>I can make changes either in SQL Server table or DAX in tabular model.</p>
  
  <p>NB: I cannot use date hierarchy, as I use Analysis Services and Live Connection.</p>