Creating Bar Chart Multiples In One Sheet 2/2: Different Measures

In the previous post, we showed how to create bar chart multiples in a single sheet with the same measure. Here we are going to show you how to do this for different measures. Using the Superstore data set, we are going to show bar chart multiples for Sales, Profit and Profit Ratio per Subcategory. It gives a simple summary of leaders and laggards on important measures. The key is to visualize them all in a single sheet à la Tableau Prep.

Here is the resulting dashboard:

The design steps are:
1.Union the Superstore data set (Orders table) 3 times. The resulting data set gets an extra field [Table Name].

2.Create the following calculated fields:
-Mixed Measure Names

-Mixed Measures

3.Create the worksheet

Voila, in a single glance, we can view three subcategory measures in sorted fashion. The workbook can be downloaded here.