Forum Discussion

Ron's avatar
Ron
New Member
8 years ago

Filter & Calculation Help

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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