1 2 Previous Next 19 Replies Latest reply on Sep 25, 2018 6:07 PM by Shinichiro Murakami

# 4 measures in dual axis

Hello Tableau Community,

I have four measures and want to have one line and rest as side by side bars like below

I am able to achieve below - it would be a great if we can change stacked bar to side by side bar below

Thanks

Dinesh

• ###### 1. Re: 4 measures in dual axis

HI Dinesh

To achieve this, you need to convert the measure names to discrete dimensions.

Could you attach your twbx workbook for us to assist you quickly?

Thanks,

Shin

• ###### 2. Re: 4 measures in dual axis

Thanks Shin,

I couldn't attach my workbook as the size is too big,

created one with sample super store data

Please if we can mimic that - that would be really helpful;

• ###### 3. Re: 4 measures in dual axis

Could you clarify which should be lines , which should be bars -side-by-side?

Shin

• ###### 4. Re: 4 measures in dual axis

Any two bars other two lines ( year on color)

Sent from my iPhone

• ###### 5. Re: 4 measures in dual axis

I am not sure 4 measure means.

1. 4 Measure x 2 years = 8 measures

2. 2 measures x 2 years = 4 Measures

I assume #2.

To make this layout generated, need to have exact continuous date as X-axis.

Now as we need multiple years as different colors,  date needs to be normalized.

Thanks,

Shin

• ###### 6. Re: 4 measures in dual axis

Hi Dinesh,

Please check the below attached work book. while creating side by side chart it gives some problem. but i can do it partially please check it if it is correct or helpful for you.

Thanks,

Amar D. Savale

• ###### 7. Re: 4 measures in dual axis

I mean we are only looking one year.

1.4 * 2= 4

Thanks

• ###### 8. Re: 4 measures in dual axis

Please explain clear expectation.

• ###### 9. Re: 4 measures in dual axis

Sorry about that  confusion and thanks so much for your time -

I have four measures in my view to be used

Year (current year) assuming

1) Actual

2) forecast

3) Bookings

4) Same period last year measure

I am trying to show

Actual s and forecast as line chart and in the same view bookings and same period last year measure as side by side bar charts

I tried and achieved something below - but the issue is , am getting stacked bar charts instead of side by side charts!

Please let me know if you need any additional info in this regards.

• ###### 10. Re: 4 measures in dual axis

Could you attach sample data as twbx, we don't need actual data but please mock up some.

We don't want to waste our time with bad data

Thanks.

Shin

• ###### 11. Re: 4 measures in dual axis

Hey Shin,

I am attaching workbook with sample data - Dates and 4 measures  and below is output I am trying to achieve

line is actual & ( dots --> rest of year  measure ) and other two measures( Bookings and SPLY are bars ) - trying to put on same axis with monthly spit

hope it helps!

Please let me know if you need any additional info in this regards

Thanks

Dinesh

• ###### 12. Re: 4 measures in dual axis

Hope this helps.

Pivot data.

Thanks,

Shin

• ###### 13. Re: 4 measures in dual axis

Thanks very much  Shi,

I tried this approach but am unable to see pivot option in my case - do we have any work around for this ?

Dinesh

• ###### 14. Re: 4 measures in dual axis

Because the fields you picked are calculated field.

You need to pivot non-calculated field first.

Shin

1 2 Previous Next