Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi team
Looking for some urgent help on sorting my visual by a month year format as opposed to an alphabetic format.
i am using a direct query to a Saas tabular model and woul like to sort the text mm-yy column on a date key column in my model. In my view i am trying to show a view of created tickets and a cummulative count of Open tickets per month. Any ideas/solutions will be really appreciated. cheers
Solved! Go to Solution.
Cheers guys for the help, on another note just wondering if there was any ideas around modelling this back within the Saas tabular model so that it flows seamlessly into to powerbi?
Hi @Anonymous
There is no direct option to sort text month year column, try to sort manually by the following way-
For more details see the pbix file. Hope this will help you!!!
Regards,
Angad
Hi Angadk,
Unfortunately there isn't an ability to create a calculated column when running a Saas direct query to a Tabular model.
Thanks for trying 🙂
Hi @Anonymous
It seems you may try to sort this in SSAS model itself as live/direct query does not have the ability to perform sorting.
Regards,
Cherie
Cheers guys for the help, on another note just wondering if there was any ideas around modelling this back within the Saas tabular model so that it flows seamlessly into to powerbi?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |