Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Highlight selected row in table

Hi Everyone!
I have a table visual that filters another table. When I select a row in Table A, the filtered rows show up in Table B but I want the row in table A to look highlighted. The other rows usually grey out when a row is selected but its still not prominent enough.

Any help is appreciated! Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous , parry2k, thank you for your prompt reply!

    Currently there is no direct way to highlight selected rows in a table.

    As a workaround, add a slicer from a copy table, no relationship with the source data, then create the measure as shown below:

     

    Color = IF(SELECTEDVALUE('Table'[Column1])=SELECTEDVALUE('Table (2)'[Column1]),"orange","white")

    Lastly, set the Background conditional formatting for all columns in the source table:

    Best regards,

    Joyce

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

     

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    1 year ago

    Anonymous maybe you want to play with color theme to make it more prominent.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    I tried using bold colors - so when I select a row that row is bold but since the other rows are bold, even when they are greyed out they appear to be bold
    I tried using light colors - Selected row appears dull even after selecting and all other rows seem to be normal

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Anonymous , parry2k, thank you for your prompt reply!

      Currently there is no direct way to highlight selected rows in a table.

      As a workaround, add a slicer from a copy table, no relationship with the source data, then create the measure as shown below:

       

      Color = IF(SELECTEDVALUE('Table'[Column1])=SELECTEDVALUE('Table (2)'[Column1]),"orange","white")

      Lastly, set the Background conditional formatting for all columns in the source table:

      Best regards,

      Joyce

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