How to change the background colour (or show any indication) on a selected row on a table visual?

[Anonymous]

Hi,

I have a Table visual that contains populated rows.
I would like it so when the user clicks on a row's cell, within the table visual, the entire row, or even just the cell clicked, has its background colour changed. I need some indication to clearly show which row has been clicked.
I cannot see any Table visual properties to do this. I am happy to use DAX but I will require a nudge in the right direction if using DAX.

Can this be done?

Thanks.

[v-eachen-msft]

Hi @Anonymous ,

Dax cannot get your action statement, so you may not use DAX to achieve your goal directly.  

I can indirectly implement the function you want, but your table must have a unique column with non-repeating data.

For example, I have a table named TEST which has a unique column “A” with three different data ”a” , ”b” and ”c”. Now I create a measure “You selected” based on column A.

You selected =
CALCULATE ( SELECTEDVALUE ( test[a] ) )

Then you can use a table visual and a card visual.

The card visual will show the row you click.

However it is an  indirectly way. If you want to achieve your goal in the table visual directly, I am afraid you could not achieve this feature currently, I suggest you to vote this idea in Ideas forum.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35449321-highlight-table-row-upon-clicking

Best Regards,

Eads

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