Forum Discussion
Microsoft Employeesort by column
Community ChampionCan you create a separate "Enter Data" query like:
Month,Sort
January,1
February,2
March,3
Have "Month" sort by "Sort". Relate the two tables on "Month" and use the "Month" from this new table instead of from the other table?
Post PatronThis idea occured to me too. But Enter data is grayed out when you're using live connection
- Greg_Deckler
Can you use the "hidden column" trick. Basically, add both the month name and the month number as columns in the table and then shrink the month number column down so you can't see it and then use the visualization controls "..." to sort by the hidden column.
MP_123 Are you hitting a Table or View in your DQ? If you use Views when accessing data via DQ you can easily handle any additional data requirements for your modeling from the source database.
problem with that is if you pin this visualisation to a dashboard the hidden month number column unhides it self!
MP_123yes, can't enter data on direct Query.
v-sihou-msftSince you are using Direct Query, you can't do any modeling within Power BI Desktop. There's no other way better than add this "description column" in source database.
Regards,
- Greg_Deckler
jirineoral, yeah, I don't work a ton with live connections but I figured that might be the case.
