Can you sort on a field not displayed in the Table report

[MarkusEng1998]

I have a schedule, where there are multiple variations of the ItemRef code. e.g. EAC, ACT1, ACT01, ACT1b, ACT-1, ACT-20, ACT-01b, etc.   But, I want the report to sort alpha-numerically on the ItemRef field.

I created a ItemRefSortRevised column: ACT-01, ACT-01b, ACT-20, EAC, etc.

But I don't want to display this in the table, which I use as a printed PDF report.

I do a hack by hiding the scroll bar with a white box, but when I publish this, the alignment changes defeating the purpose.

Per the screenshot, I want to sort on the ItemRefSortRevised column, but do not want to display it.

The original reference codes ItemRef is in the first column of this report.

Thank you for any suggestions!

Cheers.

[thedatahiker]

@MarkusEng1998  You first need to click on the Ref column in the "Fields" section and sort that column by using "Sort By Column" and select from the drop-down ItemRefSortRevised. Once you have done this, then you sort your table by the Ref column.

[MarkusEng1998]

Sorry, I guess I don't understand. Yes, I am able to follow your directions, but it still adds the field to the table, causing the scroll bar to display. I do not want the scroll bar to display if I have to add another field to the table.

[thedatahiker]

@MarkusEng1998 You need to sort ItemRef by ItemRefSortRevised 

here is some documentation on how to do that: Sort one column by another column in Power BI Desktop - Power BI | Microsoft Docs

[MarkusEng1998]

Hi @thedatahiker, yes I saw that. But I don't want to include the ItemRefSortRevised field in the table. I only see fields that are in the table to sort from. The screenshot shows a similar table without the ItemRefSortRevised field. Please note that I can only sort on fields in the table. In other words, am I able to hide that field in the table?