Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Edit pivot table chart in google data studio

I am creating a pivot table chart in Google Data Studio for user retention.

I am struggling with editing the style of the graph.

Here is how the graph looks like:

-s

I would like to:

  1. remove the table header. (saying "period_after_acquisition / act_users")
  2. Center the dimension label (1, 2, 3... identifying the "periods_after_acquisition" aka the first purchase)

I looked into chart > pivot table > style panel but it doesn't seem possible to.

like image 821
chopin_is_the_best Avatar asked Apr 25 '26 15:04

chopin_is_the_best


1 Answers

1) Headers
Can be hidden by setting both the header components to blend in with the background, for example, if the background is White in colour:

  • Header Font Colour: White
  • Header Background Colour: White

2) Alignment
Currently not implemented in Pivot Tables although alignment is implemented in Tables. One approach in a Table would be to use individual CASE statements.

Google Data Studio Report and GIF to elaborate on the Headers:

like image 111
Nimantha Avatar answered Apr 28 '26 03:04

Nimantha



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!