Sort by column not working for all visuals when "Keep Unique Rows" is set as True

Hi,

Would you like to post a download link of the pbix file with this issue without the sensitive data if it’s possible and we can help you to check if it’s an existing issue in the Power BI?

It will be better if you can upload the download link of the video of the reproducing steps of this issue.

I also suggest you to make sure you have updated to the latest version of the Power BI desktop.

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

Hi,

Unfortunately I'm not able to provide link of the pbix file since we are using Azure Analysis service with live connection.

Hope you are able to investigate this issue based on the below demonstration.

Best regards,

Henri

Hi, 

If you can’t provide link of the pbix file and want to get a solution for this kind of sorting problem as soon as possible, I suggest you to open a support ticket to get the direct help from the technical support team of Microsoft so that they can have a remote session with you on the local PC that can reproduce the same issue to make sure if this is an issue existing in the Power BI.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/683031

https://powerbi.microsoft.com/en-us/support/

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

Hi,

Thank you. A support ticket has been opened for this issue.

Best regards,

Henri

OK, thanks for the quick response!

Hi henripe, v-robertq-msft 

Can you please share the final outcome of the support ticket as I still face the exact same issue more than 2 yrs after these posts.

Kind regards, Jean-Christophe - PBI Version: 2.126.1261.0 64-bit (February 2024)

Hi lesamiraux,

MS provided only a workaround for the issue. The workaround is to place a measure into tooltips and then sort the visual with that measure. Measure = VALUES(Table[Order])

Below is the solution from MS Support (two years ago):

"As, this is existing behavior for these visuals, we provided workaround in previous e-mail.

Workaround: is to add the Order column as a tooltip on the visual. This will then add it to the list of user-selectable sort options in the visual menu, and they can override the implicit sort clause.

I hope the workaround will be helpful to you now, because, a code fix is unlikely to land before April's ending release of Desktop.

Our P.G team currently investigating if we can update our default visual sort logic to be aware of the "GroupingBehavior="GroupOnEntityKey" setting in the CSDL and skip adding an alphabetic sort."