Sorting Error: Can't be more than one value in 'x' for the same value in 'y'

[AbhayRao]

Hello,

I have a dataset (screenshot above) that contains some information of a sporting event for each fixture of each round. Rounds go from Round 1 to the Final. So the data type I've set in the column 'Round' is text. But naturally when I visualize just the 'Round' column, it auto sorts it as shown below.

Then I added an index column just so that it can help with sorting in Power BI, but when I click on the 'Round' column & try to sort it by the 'Index' column, I get the below error & can't seem to figure out how to properly sort it so that if I were to make a line chart (for example), the rounds in the X-Axis are ordered from 1 to the Final. Thanks!

[jaryszek]

did anybody fix the case? 

I have the same...
Best,
Jacek

[bhalicki]

Hi @jaryszek ,

Not that I am aware of, it only seems to happen occasionally.  I would try the suggestions below (if you haven't already).  They worked for me when I had the issue.  If you can be bothered, it might be worth raising a ticket to Microsoft to investigate - no doubt it will either be a 'feature' or 'limitation', but making them aware wouldn't hurt.

Kind regards,

Ben.

[jaryszek]

thank you. 

[Navigator456]

I am having a similar issue. Does someone know how to resolve this?

[Shahfaisal · Accepted solution]

As the error message states, you have more than one value in your Index column for the same value in Round column. Please double-check. You can create a table using the two columns and quickly identify where the issue is.

[tululum]

Unfortunatelly, It's also happens at columns where is no problem with duplicity...

[bhalicki]

Hi @tululum ,

If you have time, it might be worth creating a copy of your semantic model and raising a ticket to Microsoft support for them to investigate.  Confirm you are on the latest version first and confirm that you definitely do not have duplicity.  Also delete and recreate the sort column.  You will probably have to push support to confirm it is a bug, but if so, it will make the product better for all of us.

Kind regards,

Ben.

[bhalicki]

I found the same (confirmed in Excel that there were NO duplicates).  Would suggest there is some kind of bug in PowerBi Desktop.  I ended up recreating the sort column, with exactly the same logic, and interestingly started getting errors about circular dependency.  Once I resolved this issue, everything worked as expected.  Hopefully MS identify and fix this issue.

Update: Deleted and recreated the sort column, with exactly the same logic as the temporary column and error still persisted.  Confirmed no duplicate values.  Just downloaded and installed the latest update to PowerBi desktop, restarted PC and was able to recreate a column with the same logic and sort without issues.  I suspect there is a bug somewhere.