cancel
Showing results for 
Search instead for 
Did you mean: 

Conditional Color gradient in Pivot table

SaiKumar
7 - Data Storage
7 - Data Storage

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

1 REPLY 1

ChrisS
Sisense Team Member
Sisense Team Member

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