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

     

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.