Multiple Page Level Filters

[TCavins]

I have a report with multiple visualizations, each with their own data. Each dataset has fiscal year and company as part of the columns.

I would like to create two page level filters for these columns so every visualization can be filtered.

However, since I can't have both columns be active in the modeling tab, I am unable to. How can I do this without repeating filters for each visualization?

[v-diye-msft · Accepted solution]

Hi @TCavins 

Did you try to create a bridge table that manages the relationship with other tables with Company/FY year, then drag the FY year/Company to the filter panel? 

Here's a similar post I answered for your reference: 

https://community.powerbi.com/t5/Desktop/Problema-filtro-para-todo-el-informe-Filter-issue-for-the-e... 

Please kindly check whether it helps.

[amitchandak]

Are company and fiscal year not part of different dimensions.  Not able understandwhy both can not active together 

[TCavins]

Each visualization has it's own dataset. Different queries and underlying SQL sources, somewhat related so they are shown on the same report. The mapping doesn't let me map all datasets by fiscal year and by company. I can do all fiscal years but then company won't be active and won't filter.