6 Replies Latest reply on Feb 22, 2016 7:19 AM by Zach Leber

Line chart with one line is much higher than others

I am creating a group of lines in a line chart. The values for one of the measures is between 5000 to 6000. And The rest of them are within 0 to 600. There are several lines almost overlap each other since the scale for y axis is too big. That’s why I want to separate the largest one from the rest of them and use dual axis. However, after duplicating the values of the measures and selecting dual axis for it, there is a problem. All values for the measures are duplicated and I could not hide the lines for others. Does anybody have any idea to solve the problem?
Thank you very much.

• 1. Re: Line chart with one line is much higher than others

Filters apply to all measures in the view so you need a different way to filter the measures. One way is to create a pair of calculated fields based on your original measures, e.g.

[Low Value]: IIF([Measures] != "Measure C", [Values], NULL)

[High Value]: IIF([Measures] = "Measure C", [Values], NULL)

Then you can plot them on a dual-axis view or dual-view dashboard. I've attached a 9.2 packaged workbook.

1 of 1 people found this helpful
• 2. Re: Line chart with one line is much higher than others

Thank you very much for your quick solution. It is the correct answer. There is one thing I want to ask. What "1" means here in the calculation "IIF([Measures]!= "Measure C", [Values], NULL)"? Thanks again.

• 3. Re: Line chart with one line is much higher than others

I think you mean the exclamation point which turns the EQUALS (=) into NOT EQUALS (!=). It comes from computer programming. I think <> is another way to write NOT EQUALS in Tableau. Here's a link to more information on Tableau operators.

• 4. Re: Line chart with one line is much higher than others

Hi Zach Leber,

Thank you for your help. And sorry for the typo. Now I got it!

• 5. Re: Line chart with one line is much higher than others

Hi Zach,

Another option you might want to try is using a Logarithmic Axis.  They can be useful in this type of situation.

And there is posting from Perceptual Edge on this very topic that shares a few different options.  http://www.perceptualedge.com/articles/visual_business_intelligence/visualizing_wide-variation_data.pdf which you could definitely build with free-floating content on dashboards.

Cheers,

Sean

• 6. Re: Line chart with one line is much higher than others

Thanks Sean, I often try log scales but always revert them to linear because business users won't be able to make sense of them, as Perceptual Edge points out in that excellent article. That's why I suggested the two graph dashboard to the original poster. Another option is to normalize all the original measures to a baseline and show percent changes rather than absolute changes.