The graph can be easily fixed with a sort. I've attached a workbook that tries to mimic what you have. If you right click whatever the field name is for the basketball metric (Def. Eff Rank, etc.) and hit "Sort" and then "Sort By Field" and choose NCAA Ranking, it should give you what you want.
Additionally you can compare two teams by putting "Team on the filter shelf. When you open the quick filter, you'll be able to choose which teams you'd like to look at. In my example, I've subsituted Product Sub Category for Team.
Hope this helps,
Bar Graph question.twbx 1.4 MB
Here's maybe a starting point to getting the inverted bar graphs.
Because it stacks two measures, you may need to make a few of these and
place them next to each other in a dashboard.
Here is a similar thread that might have some other ideas:
NCAA Ranking Question2.twbx 23.6 KB
I'll use your example here and then get bring it back to my project. In the picture you posted, chairs and chairmats create the most sales, followed by tables, boockcases, and office furnishings as a whole. Let's say instead of showing sales on the Y-axis, you were to have "ranking" and at the top where you have "furniture" you were to have "sales". Now, with the same four items on the x-axis, you were to have a bar graph where the "chairs and chairmats" would have a value of 1, and a bar graph height that would be taller than the bar graph height of "office furniture" that would have a value of 5.
Would that be possible?
Some of my problems might lie in my .xsl database that I build for this example. I have a vision in my head and quickly pieced it together to try to see if the foundation in my head was plausible within Tableau.
As far as the filters go, that definitely would work. What I am really trying to go for though is to have two dropdown or input filters/parameters in order to compare any two teams from a list that would greatly exceed the number of teams I currently have as part of this.
Thanks for your quick response.
After I posted my previous response I realized that I misinterpreted your request. In order to to assign the smallest value the biggest bar, you'll have to sort by an Index. To do this, I created a calculated field called IDX with only Index() in it.
You still want your same fields on the column shelf (I assume it's something like "Metrics" followed by "Team"). You want the second field sorted by Sales in Descending order. This is important so that the Highest value will receive the lowest Index, and the Lowest value will receive the highest index.
Then you just want to put IDX as the sole field on the Row shelf and make sure that it's continuous. Also, click the dropdown on the IDX field on the row shelf and select "Computing using Team." This should assign the highest bar value to the highest index, which is also the lowest value for each Metrics category. In my example, I put Sales on the tooltip to ensure. Sorry about the confusion. Attached is an updated workbook.