Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.

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.

Is this something possible?
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())

Hi, Samik. See attached, maybe that's what you need.
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.
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())

Thank you Andrew. Much appreciated!!