Forum Discussion
Solved
display unsorted data
Hi, I would like to display the results of a query in an unsorted format in the report. For example my query returns the following rows: Status Count DIP 1 AP...
Right-Click the column and Hide should do the trick. You must do this in the data model. Once it is sorted by index column in your data model, do not select the new index column in the actual report. It should automatically sort by the data source.
This is not working for me. I've added an index column, sorted it in power query, sorted again in data editor, and played around with hiding/unhiding the column. However, in my report, the table that I've generated either sorts the first column in alphabetical order, or I can add the index column and sort on that, but then I have to show the index column in the table.