Using Rank to Filter Visual

[hmac]

Spoiler

Hi All- I have a data set with the following columns:

Account, Category, Brand, Sub-brand, UPC, Year, Week, Units, Units Py, and Units forecast. 

Account, Category, Brand, Year, and Week are all slicers on the page. 

I have 9 visuals on the page- each one is a line chart with units, units py, and units forecast on the y axis and week on the x axis. 

I want each visual to be at the Sub-Brand level and each visual to be assigned a rank 1-9 based on units that will change based on the slicers selected. 

Is there any way to do this?

[ToddChitt]

Not sure I understand what you are trying to do. Do you have 9 identical visuals on the page, each one showing data for a different sub-brand? And then you want to RANK each Sub-Brand based on some Units?

I can't think of a way to RANK a Visual. 

You might want to re-think your visual approach. Maybe have a table or matrix that lists the 9 Sub-Brands, and show the Rank as a column in the table or Value in the matrix. Then have another visual (chart, graph, etc.) that shows the sub-brand data filtered when you select a row in the table or matrix.

[hmac]

If there are potentially 300 sub-brands I am only wanting to show the top 9- the 1st chart would show the sub brand with the most units and so on- all while changing based off the slicers selected. Does that make sense? It may not be possible in which case I can do a different visual