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

Sort two lists with aligned common values

Hi, I am using PowerBI desktop with a live connection and looking to combine two ordered lists (List 1 and List 2) so that common values are aligned as shown in the combined list below. How do I do this?

 

List 1 List 2 Combined sorted list 
ordervalueordervalueordervalue
  0X0X
  1Y1Y
0A2A2A
1B3B3B
  4C4C
  5D5D
  6E6E
2F  7F
3H  8H
4I  9I
5J  10J
  7M11M
3 REPLIES 3
affan Established Member
Established Member

Re: Sort two lists with aligned common values

Hi @alaw005,

 

Post some data from your List 1 and List 2, what you have mentioned here is not much clear. If I take the following row from your post as a sample

List 1 List 2 Combined sorted list 
ordervalueordervalueordervalue
1B3B3B

 

It is not clear how List1 and List2 are related. In the combined list here what have you taken from the List 1? As the value B is already in List 2.

 

Please state clearly what you need to acheive and also share the actual list sample data

 

 

Regards,

Affan

alaw005 Frequent Visitor
Frequent Visitor

Re: Sort two lists with aligned common values

Sorry that not clear. I am after a new sort order so that when each list is sorted the same values have the same sort order. For example value B is order 1 in List 1 and order 3 in list B. I want to sort so B etc has the same position in both lists while retaing the existing order of items. The letters represent the sequence of stops on two different bus routes.
affan Established Member
Established Member

Re: Sort two lists with aligned common values

Can you share the pbix file?

 

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.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

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

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 49 members 1,227 guests
Please welcome our newest community members: