Tables being used as filters for drill through

[qmestu]

Hi,

I have a set of 3 tables that are part of a page and are being used as a filter for the drill through functionality. When i select one of the values on the first table, the drill through button is enabled and there is a accent bar that indicates the selected value. However if i select a value on the second table, the accent bar in the first table disappears, although the selected value doesn't change. How can i make sure that it is obvious that there is a selected value in the first table?

Thanks.

[Kedar_Pande · Accepted solution]

@qmestu 

The behavior you're seeing is due to the fact that in Power BI, visuals such as tables or matrices don’t keep their selection highlighted when a different visual is selected, even though the filter itself remains active.

You can add a card visual to display the selected value from the first table.

SelectedValue1 = SELECTEDVALUE('Table1'[Field1], "No Selection")

Place this measure in the card visual. Now, when you select a value in the first table, the card will update to show that selection even if you then interact with the second or third table.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn