Sorting name column by order number column with more than one sort value for each name

[Anonymous]

Hi there, I want to sort the company name column by order number column, but the case is that e.g. for name Company X I have for version A order number 4 and for version B order number 5 (in the table we have several versions of hierarchy). Power BI can’t handle it, because each name must have only one unique order number.

I found a workaround for this:

1. I open Power Query and filter the table, so there is only one version loaded into model
2. I go to the Table view in Power BI Desktop and sort name column by order number column
3. I reopen Power Query, remove the filter, which I set in step 1 and load the table into model, but this time with all versions

The sorting that I set up in step 2 remains and works, and theoretically should‘t, because one name now has more sort numbers.

Does someone know, if it is possible in my situation to sort the column in the above described way or it may happen that the sorting will be suddenly set to default or we receive error message the next time the data is loaded?

[Anonymous]

Hi  @Anonymous ,

When you click Close &Apply in the power query, power bi desktop will provide a dialog box display status,

When the loading is completed, power bi will save the state of your loading at this time as a .pbix file for later use

You can also directly splicing the parent level field and the child level field to form a new field for sortby

Company&Version = 'Table'[Company]&" "&'Table'[Version]

Result：

Best Regards,

Liu Yang

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

[DataInsights · Accepted solution]

@Anonymous,

That should work since the validation occurs only once. After the validation is successful, the sorting will continue for additional rows.