topic Re: Get selected value from slicer when interaction is off in DAX Commands and Tips

Get selected value from slicer when interaction is off

emcus — Thu, 04 Mar 2021 19:22:34 GMT

Here's a DAX challenge for anyone interested. Easy to set up, hard to solve. At least for me, haven't cracked it yet and not sure there is a solution for it, but I always figure anything can be done in DAX, right?

Create a table with three rows. Call them A, B and C. Add two table visuals and one slicer to the Power BI report page. Have one of the table visuals interact with the slicer and the other one not. Highlight (in any way) the selected row in the table visual that does not interact.

Re: Get selected value from slicer when interaction is off

gvrajesh — Fri, 05 Mar 2021 01:57:21 GMT

Hi emcus

It's not possible when interaction is off, but we can get the similar functionality using different approach.

Re: Get selected value from slicer when interaction is off

emcus — Thu, 11 Mar 2021 07:01:45 GMT

Using only one table?