Forum Discussion
How to Connect Filters on PowerBi Service?
Hi abingle ,
Here is the sample data I created:
Headcount table:
Department
Date
Value
Month
BREW
1/1/2024
189
1
BREW MAINT
1/1/2024
234
1
MAINT
1/1/2024
125
1
OPS
1/1/2024
246
1
PKG
1/1/2024
342
1
PKG MAINT
1/1/2024
545
1
QA
1/1/2024
21
1
UTIL
1/1/2024
45
1
BREW
2/1/2024
654
2
BREW MAINT
2/1/2024
221
2
MAINT
2/1/2024
667
2
OPS
2/1/2024
67
2
PKG
2/1/2024
865
2
PKG MAINT
2/1/2024
212
2
QA
2/1/2024
324
2
UTIL
2/1/2024
32
2
BREW
3/1/2024
545
3
BREW MAINT
3/1/2024
455
3
MAINT
3/1/2024
67
3
OPS
3/1/2024
90
3
PKG
3/1/2024
56
3
PKG MAINT
3/1/2024
21
3
QA
3/1/2024
34
3
UTIL
3/1/2024
45
3
Absenteeism table:
Department
Actuals
Requirements
BREW
80
100
BREW MAINT
210
200
MAINT
289
300
OPS
378
400
PKG
456
500
PKG MAINT
567
600
QA
712
700
UTIL
805
800
In Power BI Service, open the data model of the semantic model, Then you can establish a relationship between the two tables.
Drag the Department field of table Absenteeism to the Department field of table Headcount.
After it is created, it looks like this:
Exit the semantic model and enter the edit view of the report.
Put the Department of the table at one end into the report level Filter:
You can see that Filter can affect the visual objects of both pages.
If you have any further questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
abingle when you are in edit mode, go to view > sync slicers pane.
Then select slicer on main page.
You will get something like this:
It means that selected slicer is visible only on page "Dashboard". It is not visible on pages Details and Page 1.
However, if user selects something on this slicer on page Dashboard, it will also have impact on other pages.
Additionally, for me the easiest is to just copy/past slicer from main page to another page. It will ask you if you want to sync these slicers, just choose "Sync" and you're done.
Cheers,
Nemanja Andic
Thank you! However, my problem is not connecting slicers across different pages. I need to connect the filter titled "Department" to both graphs on this page. Each graph is pulling from a different tab in the backend data source, but the department classification is the same. However, when I select a specific department on this filter, it doesn't filter either graph.