display unsorted data

[tore_bluestone]

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?

[MWithrow]

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.

[Greg_Deckler]

In your query editor, Add Column, Add Index Column. Then, switch the Sort By field from Status (Default) to Index in your model.

[tore_bluestone]

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?

[GTR · Accepted solution]

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. 

[tore_bluestone]

Hi, thanks for th esuggestion but unfortunately this doesn't work, I'm not actually quite sure what hide in report actually does becuase it certainly does NOT hide in report!

Its very annoying that Power BI insists that the data has to be sorted, why can't it accept unsorted data or keep data in the same order as in Data view.

[tore_bluestone]

That's odd I went into the query editor did a save and now it is hiding the column correctly, probably a feature 🙂