Remove Horizontal Gray Lines After Column Headers in Pivot Tables

Follow

Sam Ovenshine

January 04, 2018 15:22

Many customers have expressed interest in removing the horizontal gray lines that run to the end of the pivot table widget under the column headers:

This script will remove those lines for a pivot table:

widget.on("domready", function(w){
 var tags = $('td.phantom', element);
 for(var i=0; i<tags.length; i++) {
  tags[i].style.width = '0px';
 }
})

Result:

This was tested on 7.0.0.21003. Please note that custom scripting is not officially supported and always test thoroughly before upgrading or deploying to a production environment.

2

• 

  Ramon Lopez January 04, 2018 15:23

  this is great!!  thanks sam!!

  0

  Comment actions Permalink
• 

  Jason Singer January 04, 2018 20:21

  Love it.

  0

  Comment actions Permalink
• 

  IT Department April 03, 2018 16:40

  Be careful when using this with very long Pivots.  This code will cause the navigation controls to disappear!

   

  

  0

  Comment actions Permalink
• 

  Dima Kruchenetsky April 28, 2019 12:03

  Hi all,
  After adding this script, every time i refresh the dashboard the colour palette goes to "colour blind 2"
  Does someone else experience this problem and if so how can i make the "Pastel Rainbow" as default

  0

  Comment actions Permalink
• 

  Barry Gaffey May 20, 2020 21:10 (Edited May 20, 2020 21:25)

  This script worked for me.

  widget.on("domready", function (w, arg) {
    var td = $("td.phantom", element);
    for (var i = 0; i < td.length; ++i)
      td[i].style.width = "0%";
  });

  0

  Comment actions Permalink

Please sign in to leave a comment.