How can i user sort by other column in live/direct query to SQL server table
How can I sort a visual by a column which is not used in the visual but available in data set. I know we can do this in SSAS cube. I want to implement this for the live/direct query on top od SQL server table.
for example, months i need to sorted by month orders not by alphabets.
Thanks @ashishrj. Yes, i know in SSAS as well as load option in Power BI we can do. wanted to check whether this feature is available in DQ as well, as this is musty have feature for date intelligence.
Also it would be very helpful if you have a look at my post
Direct query to the SQL Server database, you're out of luck on sorting. I would create a YYYYMM field and make it a TEXT field. The Year Month will show up as 201605 rather than 2016 May, but it's still better than 2016 April showing up before 2016 February.
Well I was also breaking my head on getting this done, specifically with respect to month sorting based on the month number. With the help of my collegue we could find a solution.
On the PBI desktop, the "Fields" blade select the column you want to sort (the column based on which you want to sort should be present in the same table), under the "Modelling" tab at the ribbon the "Sort by Column" is enabled and you can use any other column for sorting.
This works absolutely fine for the Direct Query mode. I have used this with Azure SQL