Reorder columns for Matrix visualization (with sort order data provided from the same table)

I am trying to reorder the column order for a Matrix visualization.

So, I am trying to have "Medicare A" (ReportColumnOrder = 1) as displayed far left, then after "Medicate HMO"

(ReportColumnOrder = 2) would be next left to "Medicare A" etc.

Bottom is screenshot.

I already prepared a dataset that has the data of sort order ("1,2,3..9") matching with "PayerNameRedefined" column shown below:

I searched online, and I found a solution that is adding a query (using M language), but this case is not using column name.

I also found another solution somewhat similar, but this one is not with Matrix visualization and sorting works in visualization part when sorting was performed at Data view level. 

Given that I have a data that already provides the order (1...9), would it be a somewhat simple approach?

BTW, this particular column ("ReportColumnOrder") that has the sort order is not displayed on the Matrix visualization.

Is it possible to somehow insert this column ("ReportColumnOrder") as hidden and sort the column that way? 

I am guessing I would probably need to write a M language inside Power Query.

(I am trying to make this sort order as dynamic as possible for all other similar reports without having to insert extra code in Power BI).

Thanks for help!