How can I avoid automatically sorting in Power Bi Desktop?

[ad544935592]

 I am new to Power BI and I am working on Finance Data.

I have some particular rows and Columns which I dont want to sort alphabetically.

I want the same order I have in my Excel file.

Would it be possible if we avoid sorting in Power BI.

Awaiting response and suggestions.

[jthomson · Accepted solution]

Sounds like the sort of thing that adding an index column and telling Power BI to sort by that as needed would at least partially solve

[ad544935592]

Thank You, It worked for me.

But I would like to hide the index column in a report.

Is there any possible way?

Thank Again.