6 Replies Latest reply on Jul 6, 2017 4:08 AM by Swetha J

How to show all the 3 charts in a single line chart?

Swetha J Jul 5, 2017 11:31 PM

Hi,

I have current year MTD., Last Year MTD and Forecast MTD charts in the same sheet. based on selection of data parameter it should show the current month, last year same month and forecast same month.

I need to show all 3 in a single chart and each should show in different format of lines like below

I tried with blended axis, but can able to show only 2 charts into a single chart and not able to show all 3 charts into one.

Attached Current Year vs Last Year vs Forecast.twbx

Thanks

Swetha J

Current Year vs Last Year vs Forecast.twbx 1.4 MB

1. Re: How to show all the 3 charts in a single line chart?

Gopi Chand Jul 6, 2017 12:52 AM (in response to Swetha J)
Hi,

Im not sure about different type of lines but we can fit all three lines into one axis. File attached for your reference.

Get back to me for any confusion.

Regards,
Gopi

Lines.twbx 1.2 MB

Current Year vs Last Year vs Forecast.twbx 1.4 MB

1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
2. Re: How to show all the 3 charts in a single line chart?

Mahfooj Khan Jul 6, 2017 1:03 AM (in response to Swetha J)

Hi Swetha,

You can use measure names and measure values to show multiple measures in your chart. Follow the screenshot
Drag the measure names in filter shelf and select your desired measures which you wants to show in your chart.
Drag measure values in rows shelf.
Make continuous to your date field.

Let us know if you've any query.

Mahfooj
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
3. Re: How to show all the 3 charts in a single line chart?

Swetha J Jul 6, 2017 3:36 AM (in response to Mahfooj Khan)

Hi Mahfooj

Thanks for the response

Great, I can see all the three lines in one chart..

Can we have these 3 lines format like as line 1: ........., line 2 ---------- and line 3 _______ rather than different colors

Thanks,
Swetha J
Like Show 0 Likes(0)

Actions
4. Re: How to show all the 3 charts in a single line chart?

Swetha J Jul 6, 2017 3:38 AM (in response to Gopi Chand)

Hi Gopi,

Thanks for providing the solution in the worksheet.

So there is no option available in tableau to show all the 3 lines in different format.?

Thanks,
Swetha J
Like Show 0 Likes(0)

Actions
5. Re: How to show all the 3 charts in a single line chart?

Gopi Chand Jul 6, 2017 3:43 AM (in response to Swetha J)

Hi Swetha,

I hope so far no. Below is the link where this is already asked to Tableau in idea forum.

https://community.tableau.com/ideas/1378

But, however just go through the below blog and you may find something.
Quick tip : Creating your own dashed line styles in Tableau | Bora Beran

Regards,
Gopi
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
6. Re: How to show all the 3 charts in a single line chart?

Swetha J Jul 6, 2017 4:08 AM (in response to Gopi Chand)

Thanks Gopi!

Let me try and get back to you on this.

Thanks,
Swetha J
Like Show 0 Likes(0)

Actions