Sorting Graph/Table by Values in a Column Header

[ShaunGibbs23]

Hello,

I am trying to sort this graph (and tables) by the values in the legend group/column header of '18'. The data in this graph is a measure I have produced titled '% of Row Total'. I am struggling to have the order anything other than Provider Group and do not want the sort to be rigid, instead changing when I change the filter which would be 'year'.

For example, I would want 'University of Oxford' at the top as the percentage for the column header of '18' is the highest at 79.1% but the customer/user changes the filter to previous years, then the order of providers will likely change as the values in the column '18' will change.

I'm current transitioning from Tableau where you could sort by clicking on '18' on the table and also options on the filters to sort so any help would be greatly appreciated.

[ShaunGibbs23]

Thank you for your help. How would I create a measure to add to the tooltip that only gives that value, to then sort by? I currently have the measure Age Group that includes all ages but is there a way of creating an Age Group that only has ones with the result 18, to then filter by? @amitchandak 

[amitchandak]

@ShaunGibbs23 , In the matrix, if you use the field in the column, then you can only sort on rows or grand total of the column.

In the stacked visual, you can add a measure that is only giving that value in the tooltip and can sort on the tooltip field using three dots on visual

[ShaunGibbs23]

Thank you for your help. How would I create a measure to add to the tooltip that only gives that value, to then sort by? I currently have the measure Age Group that includes all ages but is there a way of creating an Age Group that only has ones with the result 18, to then filter by?