Forum Discussion
Service Auto-Sorting visual incorrectly
I am having trouble with the service automatically changing the sorting on certain visuals regardless of preset, saved, or structured sorting done on the Desktop or Service. On the desktop in my Date table my QTR field is sorted by a QTR_num column which it is sorted by. I have also sorted this visual using the elipses to specifically select 'sort by QTR'. The visual works fine on the desktop and never re-sorts itself or changes sorting.
The problem is on the Service for some reason, no matter how I sort the visual, once I switch back to 'Reading' mode the visual auto-sorts to a different field. I've re-saved the visual with my desired sorting multiple times, I've tried republishing the whole report multiple times, nothing is working.
View on the desktop (displaying correctly):
After publishing to the Service (change occurs?):
Go into "Edit report" to try to force visual to sort correctly:
I click "Save" and then once I select "Reading View" the visual goes back to the incorrect sorting:
Why wont Power BI service recognize the way the visual should sort? I'm at my wits end trying to fix this and it is occurring on multiple visuals.
5 Replies
- Hi there
I would suggest creating a Sort By Column in your data model. This will then always allow your data to be sorted correctly.
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-columnThere is a sort by column as well in my data model that I'm sorting by. For some reason the Service is automatically selecting a different sorting method in the visual
It is automatically selecting the 'Sort By ___ Sales Amt' field which I do not have selected anywhere while on the desktop.
