Page filter to apply to unlinked tables?

[JD0963]

Hi, I am building a dashboard and have 4 tables that are all linked based on a unique ID. My page filter works fine for these, and I am using the "parent category" column on each of these tables to filter them. I have a fifth table which is a stand-alone table and not linked to any others (except the calendar table based on the date)

This fifth table also has the "parent category" column containing the exact same fields as the others however I want to somehow have this column filter when the page filter changes. I hope this makes sense? 

I appreciate any help!

[v-shex-msft]

Hi @JD0963,

Power bi use relationship to achieve cross filter effect. If fifth table not has any relationship to other tables, it is impossible to direct apply filter effect on it.

For your requirement, I'd like to suggest you create a measure to check current column(fifth table) and all selected columns, then return tag as result. Finial, drag this measure to visual level filter of visuals who based on fifth table, filter true result tag to apply the filter effect.

Tag measure:

Tag =
VAR current_category =
    LASTNONBLANK ( table5[parent category], [parent category] )
RETURN
    IF ( current_category IN ALLSELECTED ( table[parent category] ), "Y", "N" )

Regards,

Xiaoxin Sheng

[JD0963]

Hi, I created this measure and when I add it to table5 visual level filters - i can't do anything with it? I can't select true or false?

[v-shex-msft · Accepted solution]

Hi @JD0963,

Please take a look at below sample file which include use measure as filter tag.

Formula:

Tag =
VAR current_category =
    LASTNONBLANK ( T5[Category], [Category] )
RETURN
    IF ( current_category IN ALLSELECTED ( T1[Category] ), "Y", "N" )

Regards,

Xiaoxin Sheng