Forum Discussion

CoTheiss's avatar
CoTheiss
Frequent Visitor
3 years ago
Solved

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

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.

1 Reply