Hide Pivoted Column

[JohnLemberger]

We have a case where we can’t filter a pivot because it would affect a table calculation, but we’re only interested in a subset of the pivoted results. For now, there are many extra series in the visualization that are disabled. I would be nice to have the “Hide from visualization” option affect each individual column rather than every column with the same key.

[msh210]

You can click the colorful indicator in the legend to hide that column. I believe this persists when the look is saved. Not exactly what you want, but hopefully helpful.

[cutler]

Yeah, @JohnLemberger as @msh210 suggested, hiding the series in the visualization is probably the best option for the immediate term. I’ll make sure that our product folk get eyes on this, though

[SubhasreeC]

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.

[rachel_johnson]

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.

[alexandrejourno]

Hi @cutler, have you implemented this feature by any chance ?

Thanks in advance

PS : additional question, would it be possible to hide a column based on total calculations ? or display only the first n columns, ranked by the total of the measure, instead of the alphabetical order of the column pivot name ?

[cutler]

The feature isn’t implemented, but you can mimic it by creating table calculations using pivot_where() or something or something similar to duplicate the columns you do want and then hiding the entire underlying field.

[Teemu]

• 1 for this feature

[Louis_Strauss]

• 1 for this feature

[chy353]

++1 for this too!

[Daron_Peugh]

+1 for this feature as well, please!

[John_Dingee]

• 1 for this feature !

[aalbertlevine]

Thanks, @cutler, this approach worked visually at least. However applying this to multiple tiles within one dashboard has unfortunately led to almost unusable load times.

I have a table aggregating one measure while pivoting by time frame, with some simple table calculations for % change from each previous time frame to the current time frame (MoM, YoY, etc.). Then I have pivot_where() applied to the table calculations themselves to only display results for the current time frame, with all underlying columns hidden as suggested. Seems pretty straightforward, but I guess the pivoting + table calculations + pivot_where on top of table calculations wreaks some havoc.

I’m all ears if someone has discovered a better solution for this! In the meantime, +1 for this feature 😄

[omerginosar]

+1 for this feature

[Carolina1]

+1 for this feature

[DiegoFuego]

+1 for this feature

[tnightengale_cc]

+1

[Aniello_Bossa]

+1 for this feature

[mflanagan]

+1 for this feature

[rob_aman]

+1 for this feature

[StevenB1]

+1 for this feature

[spolo]

+1

[hwimoon]

+1

[jice_lavocat]

+1 for this feature.

--

With the “Table” layouts, I can’t find a way to hide a specific pivot value (while it’s available on other visualisation layouts).

--

Edit: Fixed with @lexideveaux solution (message below) 

[lexideveaux]

Hi all, 

I would recommend hiding columns under a pivot by using the pivot_index() to select the columns you want to show. So for example, if I want to only SHOW the count measure under the cancelled pivoted value : 

i can create a table calc pivot_index(${orders.count},1) 

And then hide the original measure. Now in my visualization only the cancelled count table calc will show

[Logarithm11]

I love all the creative ideas here and the community rallying together to make this a feature. It’s a +1 from me dog. 

[Diego_Velez]

​​​​​​+1 this feature.
Pivot index calculations are very far from ideal. They come with a huge cost in loading time and when building dashboards this time is very precious. I see that the early mentions to this request are dating back to more than 5 years. 

I would very much appreciate if the developer team could give an update about their plans or not to implement a solution to hide pivoted individual columns.

Thank you

[arttum]

I’m amazed this is not supported yet. All workarounds are pretty much impractical when the table contains lots of relevant dimensions.

[nathaliazxavier]

+1 this feature

[hhophan]

It’s been 5 years since the topic was opened and still unsuported, which is amazingly slow ?

+1 for this feature for sure but it’s probably will be released in 10 years I guess.

[viktor1]

+1 from me as well. Pls. We all need it.

[bpaidy]

+1 for this feature as well.

[tom_c]

+2 for this feature from me.

[Pavlo1]

+10 from me

[Dawid]

This feature has been released. You get a new “hide” option for pivots

Along with doing the same for a particular column of a measure (in case you’re pivoting multiple measures)