Solved: Performance issue with Direct Query with SQL Azure

parry2k · ‎05-02-2016

Hello,

I have a transaction table and Date Dimension table where month name in date dimension table is formatted as MMM-YY.

I want month name to be sorted by date (Jan-15/Feb-15/Mar-15/Apr-15 and so on...), with import data I can do the data modelling but seems like modelling is not possible with direct query.

Real question is what is the alternate to sort this month name field by date?

Tnanks,

P

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Eric_Zhang · ‎05-04-2016

@parry2k

You can try:

In the visual->modeling tab, new a column="01-"&DateDimension[DT], change the column type to date, and the sort by date.

View solution in original post

Eric_Zhang · ‎05-04-2016

@parry2k

You can try:

In the visual->modeling tab, new a column="01-"&DateDimension[DT], change the column type to date, and the sort by date.

ankitpatira · ‎05-02-2016

@parry2k

You also have sorting options on visuals. So in top right hand corner for example with your column chart you can click three dots and use Sort By. Though not all visuals can be sorted this way.