Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 1aaalevel 1
LIne 2bbb

level 1

LIne 3cccLevel 2
LIne 4dddLevel 3

 

The table should show the following:

LIne 1aaa
Line 2bbb
LIne 3ccc
Line 4ddd

 

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.

    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

  • 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.

    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

     

     

4 Replies

  • Hi Anonymous 

    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

    • Anonymous's avatar
      Anonymous
      Not 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's avatar
        Ritaf1983
        Icon for Super User rankSuper User

        Glad to help and yes.

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