Conditional Color gradient in Pivot table

[SaiKumar]

Hi,

We are looking for color gradient in Pivot table, but we couldn't find any range option in color formatting and also we tried widget scripts but its not effecting in widget.

Is there any alternate solutions? 

I have attached the screenshot for reference.

Regards,

SaiKumar

[ChrisS]

Hi SaiKumar,

There is an alternative to the limited color styling options in the Pivot widget editor.  There is a robust Pivot2 API for handling many more customizations that you can define in the widget editor.

https://sisense.dev/reference/js/widget/pivot2.html

Using the API or the API + CSS you should be able to define a color gradient using the linear-gradient() CSS function.

https://developer.mozilla.org/en-US/docs/Web/CSS/gradient/linear-gradient

e.g. 

background: linear-gradient(#e66465, #9198e5);

Regards,

Chris