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

      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



        • 1. Re: Formatting History (trails) on Page Shelf - can't reset
          Robin Kennedy

          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




          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

            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