Knowledge Drop

Hide Pivoted Series from Visualization

Userlevel 4

Last tested: May 4, 2020

Let's say that you want to hide a specific series from a pivoted table. What do you do? One option is to mirror all the columns manually with a pivot_where and leave out the column you want to hide. The other option is to use some visualization workarounds.
Go to the bottom of this post for a quick workaround how to hide series.

In our example below we want to hide the series from the year 2019.

This example shows the pivot_where workaround:
Screen Shot 2020-05-04 at 1.16.12 PM.png

Screen Shot 2020-05-04 at 1.16.12 PM.png

For the quick workaround:

- In the series panel, edit the label.
- Go to this website and copy and empty space.
- Paste it in.
- Click on the colour square and insert a white hex code. #FFF works

In this example we want to hide the year 2019:

Screen Shot 2020-05-04 at 1.03.55 PM.png

Goodbye 2019.

Screen Shot 2020-05-04 at 1.11.13 PM.png


This content is subject to limited support.                



0 replies

Be the first to reply!