cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sonam7 Regular Visitor
Regular Visitor

Sorting Column Header in Matrix using Direct Query

Hi All,

I am trying to sort my column header in matrix from ascending to descending in direct query mode. Since, I am using direct query it doesnt allow me to create index columns. Can someone please tell me a solution to this.

 

Matrix Column Header sort in Direct Query.PNG

 

For your reference, my column is in following format.

 

Matrix Column Header sort in Direct Query1.PNG

Thanks!

2 REPLIES 2
Community Support Team
Community Support Team

Re: Sorting Column Header in Matrix using Direct Query

Hi sonam7,

In your image,is tis yiour result? If so,  you have sort column by ascending already. Because you have set date format , 00:00:00 will be recognized as 12:00:00am and 12:00:00 will  be recognized  as 12:00:00 pm. so your image result is correct.

285.PNG

283.PNG

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
sonam7 Regular Visitor
Regular Visitor

Re: Sorting Column Header in Matrix using Direct Query

Hi Zoe,

Yes, in my image it is sorted by ascending. However, I want it to be sorted by descending. Please see the image I am attaching below it shows that the date/time format is in ascending order.

Column Header Matrix Sorting.PNG

 

I would like to know how can I sort the date/time in descending order?

 

In Matrix sorting, I don't see the option to sort by column date/time

 

Column Header Matrix Sorting1.PNG 

 

Also, since I am working in direct query it doesn't allow me to sort using index columns. Please let me know how can I sort the date/time in descending?

 

Thanks!

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 177 members 2,131 guests
Please welcome our newest community members: