Forum Discussion
How to keep the data sort the same with Datasource?
It works, thank you very much!
You can choose sort column of your choice. Or refer to my Direct Query blog in my signature
amitchandak in this way, then need to display the sorted column, too. So for the case that we need to add an index column to do the sort, then seems not perfect to display the index column out in a table or Matrix.
Sort column takes care internally. You do not have to anything other than sort on your main column.
This is what we do
Month Year = format(Date,"MMM-YYYY")
Month year Sort = format(Date,"YYYYMM") // We make this as sort column of the month year
In visual we go and sort on Month Year. But power bi sort it on Month year Sort
It works, thank you very much!
Hi Anonymous ，
Actually you don't need to show the index column in your table, after you created the index column,
1. select the column that you want to sort in the front-end
2.click the button in below screenshot
3.choose the index column that you created
then you will found that you don't need to show the index column in your table, and the table will sort by the index column
Please try.
Aiolos Zhao