Get selected value from slicer when interaction is off
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.
