Hide Pivoted Series from Visualization (Community)

View the original community article here

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:








For the quick workaround:

- In the series panel, edit the label.
- Go to this website and copy and empty space. http://emptycharacter.com/
- 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:​

Goodbye 2019.