I don't believe there's a way to color-code the Special Order Ratio column here, because it part of your dimensions (Rows shelf) and not part of the Marks.
One way to do this would be to have two sheets: one that generates the bars and one that generates the Special Order Ratio. This allows you to build the latter sheet so that Special Order Ratio is your Mark (i.e. a text mark), at which point you can attach both color coding and tooltips.
Then put the 2 sheets side-by-side on a dashboard so that everything comes together.
2 things to remember about this method:
- You need to make sure the Department is sorted the same way in both sheets so that what's displayed side-by-side is data for the same department.
- If vertical scrolling happens (too many departments), the two sheets will scroll independently, which can be quite confusing. This technique really only works for sheets that won't scroll.
Hope that helps.