5 Replies Latest reply on Nov 18, 2016 7:22 AM by Tom W

Unstack bars(2 measures, one timeline)

Dzmitry Rybalka Nov 18, 2016 6:26 AM

Hi all,

I have a data source, where 2 measures correspond to the same date.(they are in the same row in the source table)

In this example I did it with Superstore Sales and Profits:

I need to build a bar chart ,where for every month there will be 2 bars (one for each measure) for 1 month . Is it possible to do in Tableau?(my tableau version is 9.3)

Let me know if you need any further details,

Thanks in advance!

Dzmitry

Grouped bar chart_question.twbx 384.5 KB

1. Re: Unstack bars(2 measures, one timeline)

Tom W Nov 18, 2016 6:44 AM (in response to Dzmitry Rybalka)

Haven't you done exactly that in your sample? What's wrong with the sample you've produced? I'm sure the fact the bars overlap isn't ideal.

If you are looking to do bar-in-bar, then adjusting the size of one of the series might help. I.e.
Like Show 0 Likes(0)

Actions
2. Re: Unstack bars(2 measures, one timeline)

Dzmitry Rybalka Nov 18, 2016 7:02 AM (in response to Tom W)

I know that what I want may seem not to have any sence at all,but I need to have this black/blue bars side by side, not to cover or rub each other.

People sometimes call it grouped bar chart.
Like Show 0 Likes(0)

Actions
3. Re: Unstack bars(2 measures, one timeline)

Tom W Nov 18, 2016 7:08 AM (in response to Dzmitry Rybalka)

Drag measure names onto the columns shelf, drag measure values onto the rows shelf and chose on the measures you want in the measure values pane.

You can hide the header at the bottom of the page by right clicking and selecting 'show header'
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
4. Re: Unstack bars(2 measures, one timeline)

Dzmitry Rybalka Nov 18, 2016 7:15 AM (in response to Tom W)

Thank you so much, Tom! It was very helpful. Have a nice weekend!

Best regards,
Dzmitry
Like Show 0 Likes(0)

Actions
5. Re: Unstack bars(2 measures, one timeline)

Tom W Nov 18, 2016 7:22 AM (in response to Dzmitry Rybalka)

No problem. If your question is resolved, please mark the answer as correct to close the thread.
Like Show 0 Likes(0)

Actions