Forum Discussion
display unsorted data
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.
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.
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.
