Knowledge Drop
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.