Hover/highlight color in pivot 2 tables

When I select fields in a pivot 2 table for filtering, those fields will be highlighted. If I then hover over additional fields, they get highlighted in the same color, like this:

I would like to achieve 2 things in my pivot 2 tables:

1. set the hover color different from the color of the already selected (usually filtered) cell(s). i.e. FFH gets a different color, because that's where my mouse currently is located at.

2. color the whole row when selected, not just a cell, like this:

Any suggestions are greatly appreciated.

Martha

Posted 1 year ago·Last reply 1 year ago

8 comments

Martha

OP1 year ago

Hi DRay ,

following up with a bit of a simpler question: how do I change the highlight color to something else then yellow within e.g. a widget script?

For the Compose SDK it's described here: https://sisense.dev/guides/sdk/modules/sdk-ui/interfaces/interface.PivotTableStyleOptions.html#highlightcolor

But I have no idea how to address that parameter from within a widget script.

Thanks in advance!

Martha

DRay

·1 year ago

Hi Martha,

Let me see what I can find and I'll get back to you.

DRay

·1 year ago

Hi Martha,

Does this help? It's more than your specific use case, but I believe there is good info in there.

https://community.sisense.com/t5/help-and-how-to/invert-text-color-when-over-dark-highlight/m-p/26934

Martha

OP1 year ago

Hi DRay ,

thanks for the link. As I understand, it's about colors in column/bar charts via Highcharts, but my question was for pivot tables, so it didn't help me with my problem 😕

DRay

·1 year ago

Hi Martha,

Can you take a look at this article and let us know if helps? https://community.sisense.com/t5/knowledge-base/changing-color-of-specific-cells-in-a-pivot-based-on-textual/ta-p/9201

Martha

OP1 year ago

Hi DRay,

thanks for your reply.

No, it's not about the background color conditional on the cell value. It's about coloring whatever is highlighted.

DRay

·1 year ago

Hi Martha,

Thank you for checking it out and following up. I'm not able to find anything that specifically addresses your needs, so if you like, I can work on connecting you with a technical resources who can work with you directly. Would you like me to do that?

DRay

·1 year ago

Hello Martha,

Thank you for reaching out. I see your question hasn't gotten a response yet, so I'm asking internally to try and get you an answer.