Filter & Calculation Help

[Ron]

Hi All,

Looking for some help/advice please. I have 7 tables, consisting of 1 table of fixtures and 6 other tables of varying team form.

I'd like to be able to filter all 6 of the form tables based on the values selected in the fixture table.

For example, Select a row in the fixture table which contains "Elana Torun" & "Centra Ostrow" and the 6 form tables to either highlight both teams or they filter for both teams. See screenshot for a better understanding.

[Anonymous]

HI @Ron,

AFAIK, power bi slicer or filter not support these operations.

In my opinion, you can use measure to find out related parent level based on child level items, then use measure as filter tag to control which records will display. (you need to create new table to store source column of slicer, it can't have relationship to original table)

BTW, it is impossible to get highlight items from table visual and use measure to highlight related visuals records.

Regards,

Xiaoxin Sheng