Using Tableau - SIde by Side bar chart along with 3 measures

Question

I have 3 measures - sales($), profit($) and discount (%). I want to show Sales and Profit as side by side chart over time and discount as a line chart (all 3 in one).

Is there any way to do this. On tableau community i found some useful tips but for that ill need to pivot the data. I want to avoid doing that.

Thanks a lot for your help!

Aniket

question from:https://stackoverflow.com/questions/65931875/using-tableau-side-by-side-bar-chart-along-with-3-measures

Answer 1

As you have already pointed out, in order to have side by side barchart combined with a line chart is quite tricky and needs a transformation of data.

Anyway, if you can accept to have a barchart inside the other one (say profit "inside" sales) like the following, you can get it in few clicks using measure names and dual axis.

If needed, I've even find a really good tutorial by Andy Kriebel: