Help Needed - Sort Multiple Table based on value in table A

Hi Anonymous 

Currently the matrix visual only supports to sort by Row header and Value field. To sort the column, you need to add a calculated column in the data table to calculate this year's budget in advance, then sort the category column by it. 

Additionally, it is not supported to sort a matrix visual by values in another visual. You may also need to create a calculated column to sort by in advance. Does data in both visuals come from the same data table? Is the value field a measure or a column? Can you please share some dummy data to show the original data table then we can look into it if it is possible to create a calculated column for sorting-by? 

Best Regards,
Community Support Team _ Jing