Forum Discussion
How can i sort months in Power BI when get data from direct server?
i saw that is easy manipulate data when this is import, but when i connect directly whit the server can't do that (at least not intuitively). I need sort the months in a data segment but don't appear options for the data for do this task.
4 Replies
- Fowmy
Super User
Lucho20724
Not clear enough to understand the problem,
Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.Click on the Thumbs-Up icon if you like this reply 🙂
- amitchandak
Lucho20724 , In case of direct query you can create a few columns
like
Month year sort = year([Date])*100 + month([Date])
https://www.youtube.com/watch?v=My0bLn9voo4&list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA
I have a connection to a data source from analisys services. I put a sample of how I am visualizing the data in the data segment that I use as a filter. These are seen in alphabetical order but I need them to be arranged chronologically. I put the image of the days since I would also need to order it (1,2,3, etc.) but it orders it as if it were a string (in the database it is an int). And since the data is obtained directly from the server I have no option to manipulate the data. Thanks for the help
v-xuding-msftCommunity Support
Hi Lucho20724 ,
There is an video about How to sort month name in Power BI while using direct query . Hope it can give you a few ideas.
