PowerBI - apply single field filter to multiple datasets?

Full disclosure, I am a powerBI n00b. I am working on a report for data generated by an external system. This system exports data into different tabs in an excel sheet(lame, I know). I am needing to get a single filter to filter data from all 4 data sets. Let's say this column is last name. I have tried to create these relationships, and it seems to work....however I am convinced this is not the proper way to handle this.

  • Dataset1.Lastname -- Dataset2.Lastname
  • Dataset2.Lastname -- Dataset3.Lastname
  • Dataset3.Lastname -- Dataset4.Lastname

Cardinality of Many to Many, and a cross filter direction of both for each relationship

Does anyone know of a better way? Thanks in advance(and I apologize for being obtuse)!

Topic best-practice powerbi

Category Data Science

About

Geeks Mental is a community that publishes articles and tutorials about Web, Android, Data Science, new techniques and Linux security.