Forum Discussion
Month Order in stacked column chart
Hi coolie ,
Thank you for reaching out to Microsoft Community.Ensure your month name is sorted by a numeric month value and this needs to be present in your data model.
If your table already has something like:
MonthName = "January", "February", etc.
MonthNumber = 1, 2, 3, ..., 12
Now in the Data Modelling tab, click on the MonthName column
Choose Sort by Column > Month number
Refresh your visual, the months will now appear in the correct order.
To avoid repetition of month names as shown in the second chart, make sure your visual X-axis field is not too granular. Grouping by Year and Month number instead of full date helps.
Hope this will help.
Best Regards,
Chaithra E.Turns out much simpler than this - you create your date hierarchy in the semantic model in the way it describes in the link above, but as long as you have a date field in your table you dont need to a separate dimension table. You can create a view to add the other fields in the hierarchy if necessary.
Managed to sort it using this link from MS but still took some working out. Downside with this is that you have to have all possible dates in the dimension table you create, so not really the best solution:
Solved: Re: Missing Date Hierachy Lakehouse Model - Microsoft Fabric Community
Turns out much simpler than this - you create your date hierarchy in the semantic model in the way it describes in the link above, but as long as you have a date field in your table you dont need to a separate dimension table. You can create a view to add the other fields in the hierarchy if necessary.