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.
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.
That's odd I went into the query editor did a save and now it is hiding the column correctly, probably a feature :-)