Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Data Slicer Filtering

Hello All - Need some HELP!!!!!


What I have is two spreadsheets

1. Master - Holds multple weeks of data

2. Current - Is a copy of the (Master) but have set a filter to it to just show me the data from the most current week ending date.


I have a sheet that has multiple charts on it. Most of the charts are based on the "Current" table. But there are also some charts that are based on the Master table.


I have included multiple slicers to sort through data. (Company, Department, Area, Team)


What I am trying to do is when I select Company, i want the Department slicer to filter only based on the data that is there, and the charts to reflect the selection. 


The issue is when I apply the Comapny from the Current table it only chnages those graphs (Current) and vise vera for the Master. 


I haver also created a "Company" table of its own, and then linked "Company" to both the Master file and Current. That dont work either......


Looking for suggestions! 

Frequent Visitor





this is not the model

it should contain the tables and the relations 



Resolver II
Resolver II


can you show us the model ?

Hopefully someone can help fix!!! Not sure why its not filtering the data.



Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors