cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andrewfayj Frequent Visitor
Frequent Visitor

Sort by first column and then sort by 2nd column alphabetical

I'm looking to sort by the first column based upon number value and then sort from there based upon an alphabetical order in the second column.

 

For example, my first column is the year and I wish to sort by year first. I then want my second column to have grouped values based upon alphabetical order. So a name starting with A - "Application" will all be grouped for 2018, then again for 2019.

 

Is this possible? 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Sort by first column and then sort by 2nd column alphabetical

Hi @andrewfayj,

 

What visual do you want to use?

 

As I know, the default sorting order in Power BI could meet your requirements.

 

Untitled.png

 

If you still need help, please share some data sample and your desired output, so that we can help further investigate on it?

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Sort by first column and then sort by 2nd column alphabetical

Hi @andrewfayj,

 

What visual do you want to use?

 

As I know, the default sorting order in Power BI could meet your requirements.

 

Untitled.png

 

If you still need help, please share some data sample and your desired output, so that we can help further investigate on it?

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 46 members 1,113 guests
Please welcome our newest community members: