Forum Discussion

mocno1's avatar
mocno1
Frequent Visitor
5 years ago
Solved

Cross filter

Hi everyone, I am new to Power Bi. Currently, I have tried to build a dashboard for HR Management which includes some fixed employee information like Name, DOB, Gender, Joining Date,... and other in...
Need Help
  • mussaenda's avatar
    mussaenda
    5 years ago

    Hi mocno1,

    What you can do is to create a bridge table that contains both of the data and connect them to your fact table then use it as a filter.

    That will affect both of yor charts.

     

    Hope this helps.

mocno1's avatar
mocno1
Frequent Visitor
5 years ago

For my case, now if I filter "Gender" on the right chart, the left chart will change accordingly.

On the other hand, if I filter "Class" on the left chart, the right chart does not change at all.

In actual, I have several charts for "Working place", "Title" which are similar to "Class". I want that when I filter "Class" or "Title", the other charts for other information will be changed and vice versa.

mussaenda's avatar
mussaenda
Community Champion
5 years ago

Hi mocno1,

What you can do is to create a bridge table that contains both of the data and connect them to your fact table then use it as a filter.

That will affect both of yor charts.

 

Hope this helps.