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, 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 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!