How to sort a table by column not included in the table

[MouserMike]

I created a calculated column (below) in order sort a table by two columns (name and date).  By adding this column to the table, I can sort by this column and I get the expected results.

New Sort = Assignments[ResourceName] & FORMAT ( Assignments[AssignmentStartDate].[Date], "yyyy/mm/dd" )

However, I don't want this column to be visible in the table; the individual columns are already there, and this calculated column looks rather weird since it's multiple columns concatenated together.  I've looked for ways to sort a visual by a column that is not part of the visual, but the only "solution" I've found is to add this calculated column to the far right of the visual, then shrink the width so it's almost invisible.  Is there another way to do this?

[Greg_Deckler]

One thing you might try. Choose a column that is already in the visual and how you are sorting now. Change the Sort By column for this column to be the New Sort column you created. Modeling tab.

[JosefPrakljacic]

Hello MouserMike,

you sort your columns by your "NewSort" Column and then you hide the "NewSort" Column. You can do it also the other way around.

I recommend to do that in the data view (Point 1 in the Screenshot) in order to see your hidden columns.

The hidden column can still be used for ordering.

I hope I understood you right.

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef