CODEWITHSUNDEEP
powerbi
abc000
abc000

Reputation: 1

Multiple independent slicers on the same table column

I have a table called Parts that contains a list of mechanical items, with columns like serial number and description. I am displaying the data as a matrix visual and I have a slicer on serial number. By default, some of these items should not be displayed because in most use cases they are not relevant, which I can do by filtering with the column DefaultExclusion = FALSE.

Some users, however, need to be able to re-introduce some of these items and my requirement is to have two slicers: the first one displaying only the items with DefaultExclusion = FALSE (initially all selected), the second one displaying those with DefaultExclusion = TRUE (initially all unselected and not displayed in the matrix visual). The expected behaviour is that:

I thought of creating a measure called ShouldBeDisplayed that gets the selected items from the two slicers using VALUES() and checks row by row if SELECTEDVALUE(Parts[SerialNumber]) is IN the slicer selected values, and then filtering the matrix visual by this measure, similarly to what was suggested here: How to set OR logic between two slicers for the attributes from same dataset? Unfortunately, this approach does not work because my dataset contains few millions of items and it's too resource intensive.

I also cannot use bookmarks because users will create their own to save some slicer preselections, which would interfere with any bookmark I create.

Is there another way to achieve this goal?

Upvotes: 0

Views: 59

Answers (1)

Arya
Arya

Reputation: 341

Try this: Create 2 table with ItemList for DefaultExclusion = FALSE and DefaultExclusion = TRUE Add these 2 as a 2 separate slicers (make sure the new table are not connected to actual table)

Create a Measure to calculate selected values from either of the slicers

e.g.
Filter_ItemCount = 
Calculate(DistinctCount(Data[Item]), filter(Data, Data[Item] IN VALUES(ItemList1[Item]) || Data[Item] IN VALUES(ItemList2[Item]))

and apply this measure in the filter pane saying Filter_ItemCount IS NOT BLANK

Upvotes: 0

Related Questions