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!
Hi abingle ,
Your solution is great, nandic . It worked like a charm! Here I have another idea in mind, and I would like to share it for reference.
When you open a report in Power BI Service, the default view is Read view, and you need to enter Edit view if you want to edit Slicer or Filter.
Access the report editing mode in Power BI Service.
Make sure to create relationships between your department table and other tables.
Try applying department filters at the report level.
Drag the Department field to the Filters pane on the right and set it up under the Filters on All Pages section.
Please see this document for more details:
Add a filter to a report in Power BI - Power BI | Microsoft Learn
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If 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!
Hi, thanks! However, is it possible to create relationships between tables in PowerBi Service? Could you please help if so?
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!