Forum Discussion
PBI Won't Sort My Data like the Table View
Hello, I am building a report and having trouble with one of my tables on the report view. When I switch to Table view, the sort order is correct, but it is completely different on the report. ...
Greg_Deckler
Community Champion
Community Championqueryguy48 Maybe add an Index column and use a Sort By column for Length of Service referring to the Index column. Then it should sort in the order in which it comes in from the Excel file. If an Index column does not work because you have duplicates 1 years -> 1, 1 years -> 24, then you would add a conditional column where you would map 1 years to 1, 2 years to 2, 3 years to 3, etc. and then use that as your Sort By column.
Thanks Greg! This got me really close to fixing the issue. However, the table view will only sort by my index column if I include the index column in the table. I'm trying to find a way to hide the Index column.