Control to Hide All Pivot Column Fields in Visualization

Hey there! I was hoping it might be considered to implement a way for us to hide all the pivot columns from a visualization so that it will be possible to quickly view just individual column metrics by selecting them and unselecting them.

1 Like

Hey @Eric_Walisko!

If you click on the gear icon you can select ‘Hide from Visualization’ which will remove that pivot column from the chart. If that isn’t what you’re looking for could you provide some more details on what you would like. If you have a specific use case you can visit help.looker.com with the details.

Thanks,
Rachel

[Image of all selected (default) would have gone here]

I’m actually looking to quickly turn my visualization from the above to the below:

[Image of all unselected would have gone here]

so that I can quickly hone in on the trend of a single or few columns like below:

It seems like there should be a better way than just manually unselecting each color.

Sorry if my post is unclear, it would have been more clear if I was able to include the first two images but I am a new user so I am not allowed to post more than one.

@Eric_Walisko, thank you for clarifying. Good news, we have a shortcut for that. You can select just one series in the legend by holding the option key while you click. Here’s a gif:

Beautiful, thank you all!

Hey Rachel, Is there a way to remove on the of the values in the pivot column? When I select hide from visualization for the pivoted column it hides all the categories under the column.

1 Like

Hey @SubhasreeC,

At this time there is not a way to hide only one column within the pivot from the visualization, but I will definitely let the product team know this is something you’d like to see! Hiding one series is possible via the visualization legend and by holding the option key while clicking as shown above.

1 Like
  • 1 for this feature