2 Replies Latest reply on Jan 9, 2013 7:21 AM by Matthew Reeve

    Formatting History (trails) on Page Shelf - can't reset

    Matthew Reeve
    Matthew Reeve Jan 7, 2013 4:39 AM

      Happy New Year!

       

      Is it possible to reset the formatting for a history line on a page without having to go "back"? I inadvertently set a colour for a trailing line (to show movement over a year) and this lost me the colour as per the color shelf. Now, having made significant changes to the file, I want it back to default, but without having to recreate the worksheet.

       

      Is this possible? The Page shelf History/Formatting dialog doesn't allow me to select "none"...

       

      Thank you if anyone can help me.

       

      Best wishes

       

      Matthew

        • 1. Re: Formatting History (trails) on Page Shelf - can't reset
          Robin Kennedy
          Robin Kennedy Jan 7, 2013 5:17 AM (in response to Matthew Reeve)

          Happy new year to you too!

           

          Hmm... you know what... I don't think there is an option to do this using the UI!  How odd... an oversight in the design perhaps.

           

          The good news is you don't have to start from scratch. The bad news it you will have to do this by fiddling with the XML. Close down Tableau and open your workbook using a text editor (preferably something like Notepad++) and search for the text

           

          <page-trail-options

           

          under the relevant worksheet, you need to edit the attribute "line-color-auto" -- change it to true from false and save then close.

           

          Reopen the workbook in Tableau and you should be back to automatic colors depending on what's on the Color shelf.

           

          P.S. Please save a backup copy of your workbook before you edit the XML just in case!

          • 2. Re: Formatting History (trails) on Page Shelf - can't reset
            Matthew Reeve
            Matthew Reeve Jan 9, 2013 7:21 AM (in response to Robin Kennedy)

            Dear Robin

             

            Thank you ever so much for that reply. That is really useful, and I had no idea about the XML file behind. It's helped in a couple of other puzzles I'd had, so I am very grateful.

             

            Best wishes

             

            Matthew