setup a slicer that slices multiple fields (that have the same values)

[CoTheiss]

I am trying to setup a slicer to filter on a single field that is available in every table.

Every table has a field "updatedBy" to show who recently modified a particular entry - additional to that, there is also a field called UpdatedByCategory - which contains e.g. any of the following values: Job, internal staff, service provider

Now, the slicer should enable the user to easily display all the entries that were created by e.g. the service provider.

Therefore, I need to set a filter in every of the three tables (Manufacturer, Contracts, Products) with where [Tablename].UpdatedByCategory = SelectedValue from slicer.

I tried to solve this with a data island called UpdatedByCategories, set the slicer based on that and implementew a new column in each of the three tables that checks if [Tablename].UpdatedByCategory = SelectedValue from slicer.

Unfortunately, this never worked when I select something - additionally - it should also work if nothing is selected or if multiple values are selected..

Any ideas how to solve this ?

Also, maybe my data island idea is not the go-to solution for this as-well ... this is just how I would have solved it with another tool.

But as e.g. the manufacturer can be modified by person A but the products could be modified by Person B and Person C, connecting the slicer base-table to the data model did not make sense in my mind.

[Anonymous · Accepted solution]

HI @CoTheiss,

Current you can't use one filter to control different table fields at the same time, power bi will use 'AND' logic to link different filter and tables based on the relationship keys.

For this scenario, I'd like to suggest you break/turn off the relationships and use Dax expression to apply filter effects on visuals. 

USERELATIONSHIP function (DAX) - DAX | Microsoft Learn

Applying a measure filter in Power BI - SQLBI

Regards,

Xiaoxin Sheng