4 Replies Latest reply on Jan 15, 2019 8:34 PM by Glenn Page

    Highlighting points on multiple graphs for a year

    Glenn Page

      Hi there,

       

      Still relatively new to Tableau and am seeking some help on how I highlight (with a dot for example) the years 2007, 2008 & 2009 on the attached workbook in each graph as these were years with wage increases which is important to know for what's happening in the graphs...

       

      Thanks in advance

        • 1. Re: Highlighting points on multiple graphs for a year
          Ken Flerlage

          First of all, this is really good work! Looks great. I'm surprised that you're new to Tableau.

           

          Adding these dots is tricky because that would require use of a dual axis on rows, but you're already using that. Let's pretend for a moment that you're not using it for the label. You could create a calculated field like this:

           

          Dot

          // Measure just for these three years so we can plot dots.

          IF [Year]=2007 or [Year]=2008 or [Year]=2009 THEN

              [Below Minimum Wage]

          END

           

          Then use that as a dual axis.

          But you also need the labels for each chart, which makes this tricky. Still thinking about how I'd approach it but wanted to get some thoughts down.

          • 2. Re: Highlighting points on multiple graphs for a year
            Glenn Page

            Thanks Ken.  And yes found the same thing...using up all my dual axes!!!

            I wonder if there is a way to shade the same period and then have a call out box somewhere with the explanation??

             

            But I do really like the 3 dots...

             

            Thanks for your efforts

            • 3. Re: Highlighting points on multiple graphs for a year
              Ken Flerlage

              Could use a reference band like this:

               

              Here's another idea. I don't love it, but it may work. If you're using 2018.3, the you can leverage transparent sheets. Create a copy of the sheet, then on that copy, make the line color 0% opaque (i.e. transparent), make all the axis header text and title white (to match the background), and turn off all the lines. It should look like this:

              Then, on the original sheet, change it to be the dotted line like I showed before:

              Now, on the dashboard, drag the label sheet onto the dashboard. Next float the chart sheet on top of it. Using the Layout panel change the x and y positions to 0 and make the width and height the same as the dashboard overall. Finally, right click on that sheet, choose format and change the background to None.

               

              The result will look like this:

              It's hacky but might work.

              1 of 1 people found this helpful
              • 4. Re: Highlighting points on multiple graphs for a year
                Glenn Page

                Wow thanks so much Ken.  A little hacky but the outcome I was looking for!

                 

                Called you out on Twitter too as this was for #MakeoverMonday!