Forum Discussion
different row colors depending on a specific column value
I have a table with a bunch of rows and I would like to highlight some of them with a different color, the condition should be set
by a column that is not shown in the table.
example, I have this data:
| Line 1 | aaa | level 1 |
| LIne 2 | bbb | level 1 |
| LIne 3 | ccc | Level 2 |
| LIne 4 | ddd | Level 3 |
The table should show the following:
| LIne 1 | aaa |
| Line 2 | bbb |
| LIne 3 | ccc |
| Line 4 | ddd |
With lines 1 and 2 in a different color (due to paramenter "Level 1")
Anyone knows if it's feasible?
Many thanks in advance
Hi Anonymous
Yes, you don't need to have a column of condition on your visual.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Anonymous
1. You can create a measure for the desired legend :
circles are from here :
https://getemoji.com/assets/#objects
(just choose these you need and copy and paste them into the measure)
2. Add "I" or another button to your table:
3. Add a tooltip to the button with your legend measure
result :
You can group this "button" with the table
The demo file is also updated.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
4 Replies
- Ritaf1983
Super User
Hi Anonymous
Yes, you don't need to have a column of condition on your visual.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- AnonymousNot applicable
Fantastic, many thanks indeed.
Do you know if there's a way to add some text inside the table box in order 2 explain what each color means?
In that example would be something like
"red = 1"
"blue = 2"
Ideally showing a little box with the color.
Many thanks
- Ritaf1983
Super User
Glad to help and yes.
I explained in other discussion include demo. Will attach a liink later ( not near computer now)