Cross-highlight behave as cross-filter on visual

[Elbartje1]

Hello all,

I want to select a row in a table and this should filter a column chart visual.

Standaard highlighting doesn't remove the unrelated data it just highlights the related data.

I was trying to write a measure that retrieves the selected value in the table and then uses this to add an extra filter on the data from the column visual but this was not working.

What I tried:

Get data from table:

Filter_value= FIRSTNONBLANK(table[name], TRUE())

Add extra filter on data and calculate measure:

CALCULATE(expression, FILTER(table2,table2[name]=Filter_value))

• But is does not work.

[Elbartje1 · Accepted solution]

Solved my own problem, its a standard setting in powerBi:

Under edit interactions you can choos the filter icon, that simpel 😄