Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Tatynout
Contributor III
Contributor III

Color expression condition on indicator representation in a table cell

Good day all,

I ave the following QS sheet:

Tatynout_0-1595854290002.png

The values in columns "Weeks" and "Target" of my table dynamically change depending on the button selection. In my weeks column, i have an indicator representation with a conditional color with the following rule: If  my value(Weeks) is greater than the corresponding Target then Green or else red. Therefore, the indicators on my first and last line should be red.

The issue now is that the conditional expression on color of my table chart can only be done with the limit option and do not allow me to use the corresponding target as a limit under my weeks measure:

Tatynout_1-1595854869471.png

 

Does anybody please have an idea on how to solve this?

 

Many thanks.

 

Regards,

Tatiana

 

 

Labels (2)
2 Replies
tresesco
MVP
MVP

May be use background/text color expression, instead.

NewLookListens
Contributor
Contributor

It's commonly utilized as a center pointer, to show which component will get input occasions NewLookListens.