different row colors depending on a specific column value

[df123445]

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 

[Ritaf1983 · Accepted solution]

Hi @df123445 

Yes, you don't need to have a column of condition on your visual.

Link to demo file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983 · Accepted solution]

Hi @df123445 

Yes, you don't need to have a column of condition on your visual.

Link to demo file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[df123445]

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 · Accepted solution]

Hi @df123445 

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.

Link to the demo file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983]

Glad to help and yes.

I explained in other discussion include demo. Will attach a liink later ( not near computer now)