Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
neatdot
Helper I
Helper I

Highlight a filtered row in a visual with interactions turned off

I have the following table in my data model:

 

Picture10.png

 

I have created a Table visual and a slicer based on Table1, and a slicer based on the Attribute column. I have turned off visual interactions between the slicer and the Table visual so that all rows in the table are always displayed. However, I would like to highlight the selected row in the Table visual as indicated below. Does anyone know whether this is possible?

 

Picture1.png

Many thanks

Steve

1 ACCEPTED SOLUTION
tex628
Community Champion
Community Champion

To my knowledge it's not possible to work around the edit interactions functionality, as if there is a relationship there will be no trace of the sliced values when calculating in the table visual. 

I would work around this with a unrelated table, I don't know if this could work for you but take a look at the pbix attached and see if it might help:


image.png


Connect on LinkedIn

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@neatdot , once you turn off the interaction. You will not be able to use the filter value

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
tex628
Community Champion
Community Champion

To my knowledge it's not possible to work around the edit interactions functionality, as if there is a relationship there will be no trace of the sliced values when calculating in the table visual. 

I would work around this with a unrelated table, I don't know if this could work for you but take a look at the pbix attached and see if it might help:


image.png


Connect on LinkedIn

That will work for me - perfect! 👍

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.