Forum Discussion
nleuck
Post Patron
Post PatronPower BI sorting issue with data connection to Analysis Services
Hello All, There seems to be an issue with how Power BI sorts numeric month values from a Live Connection to Analysis Services. If I select Month Number from my Date table (in our database this ...
LivioLanzo
Solution Sage
Solution SageI know, I meant to check on SSAS side
nleuckPost Patron
Post PatronIt's sorted in chronological order.
nleuck,
In my scenario, Month number shows in an expected order in Power BI Desktop. Please make sure that your monthnumber field is sorted correctly on SSAS side. And you can post question about SSAS sort in SSAS forum to get better support.
Regards,
Lydia