Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Straight Table - Highlight Selected Fields just like List box

Hi,

I am having a Straight Table for which I am displaying "All Values" for Dimension and removing check on "Suppressing Zero Values" so that I can view all the available options.

But when I select one of the value, its not showing which value I have selected.

aa.png

As you can see above, I have selected 1000,2000 & 5000 but its not highlighting the row as if it was a list box below.

vvv.png

Is this something possible?

1 Solution

Accepted Solutions
andrey_krylov
Specialist
Specialist

Of course.   Chart Properties -> Dimensions -> Used Dimensions -> Status History -> Background Color

And there is  the expression

=If(GetSelectedCount([Status History]) > 0 and Match([Status History], $(=Chr(39) & Concat([Status History], Chr(39) & Chr(44) & Chr(39)) & Chr(39)) ), LightGreen(), White())

View solution in original post

4 Replies
andrey_krylov
Specialist
Specialist

Hi, Samik. See attached, maybe that's what you need.

Anonymous
Not applicable
Author

Andrew, you got exactly what I wanted. But I am not able to get how you did that in the file.

Can you please provide the exact screenshot of section where you did it.

andrey_krylov
Specialist
Specialist

Of course.   Chart Properties -> Dimensions -> Used Dimensions -> Status History -> Background Color

And there is  the expression

=If(GetSelectedCount([Status History]) > 0 and Match([Status History], $(=Chr(39) & Concat([Status History], Chr(39) & Chr(44) & Chr(39)) & Chr(39)) ), LightGreen(), White())

Anonymous
Not applicable
Author

Thank you Andrew. Much appreciated!!