How can i sort months in Power BI when get data from direct server?

[Lucho20724]

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.

[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

[Lucho20724]

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-msft]

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.

[Fowmy]

@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 🙂

YouTube, LinkedIn