Forum Discussion
Anonymous
8 years agoNot applicable
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...
GilbertQ
8 years agoSuper User
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-column
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-column
- Anonymous8 years agoNot applicable
There 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.
- Anonymous8 years agoNot applicable
HI Anonymous,
Have you try to sort by column feature to specific 'qty' column as sort order of 'amount' column?Regards,
Xiaoxin Sheng
- Anonymous8 years agoNot applicable
Anonymous
I'm sorry, I'm not entirely sure what you're asking me. I am trying to specifically sort by column 'qtr' which is set as my sorting method on the desktop both in my data model as well as on the visual.
Could you clarify your question please? Thanks for responding