Edit pivot table chart in google data studio

user_5436714 0
Viewed 2585

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.

google-data-studio
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:

user_128925530
Related