Tableau: How to create a Side by Side Bar Graph with Overlaying Line Chart
Updated: May 13, 2021

Step 1:
Select all of your metrics. Right click one of them. Select Transform > Pivot. This will give you pivot field names and pivot field values.

Step 2:
Create this calculated field for your bar values.
If [Metric] = “Metric1” or [Metric] = “Metric2” then [Value] end

Step 3:
Create this calculated field for your line values.
If [Metric] <> “Metric1” and [Metric] <> “Metric2” then [Value] end
