Sort on multiple visuals (Matrix) at the same time possible?

[JustinDoh1]

I am sharing my Pbix file here.

I am trying to see if it is possible sort two visuals at the same time.

For instance, if user clicks the sort button on the "Facility Name" on the Today matrix, I would like the sorting of "Facility Name" for the Variance matrix to follow.

Is it possible?

If it is not possible, how do I create a separate column that I could insert into Today matrix (as an extra column)?

This is the detail of the measure I user for Variance table:

MeasureDayBefore = COUNT('vw_daily_today'[ClientID]) -
                                   COUNT('vw_daily_priorday'[ClientID])

If these two options are not possible, is there any way to disable sorting (maybe that way, I don't have to worry user clicks sort on visual by accident) on Matrix visuals? 

Thanks.

[JustinDoh1]

@VahidDM Thank you for your feedback. Is there anyway to "sort" two visuals together? Thank you.

[VahidDM · Accepted solution]

As far as I know, thre is no way.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[VahidDM]

Hi @JustinDoh1 

Check this link to find a trick to disable the Sorting:

https://community.powerbi.com/t5/Desktop/How-to-disable-sorting-in-Table-visual/td-p/1240794

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/