Forum Discussion
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
APP 2
OFF 0
SET 1
But the report sorts this alphabetically, on column Status, into:
Status Count
APP 2
DIP 1
OFF 0
SET 1
How can I force the report to keep the same sequence of rows?
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.
6 Replies
In your query editor, Add Column, Add Index Column. Then, switch the Sort By field from Status (Default) to Index in your model.
Thanks for this, I added the index column to the report but I don't want to show this column in my final report, is there some way of making it invisible to the end user?
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.
