Minimum Default Slicer Selection

[Cantona_lives]

Hi all,
I have a slicer with many items, but I always want one specific items selected. Is there a way to sure this is the case, while allowing additional selections?

For example -

Item 1 is always selected, even in teh even of 'clear all' or if one other item only is selected.

Items 2, 3 and 4 can also be selected, building upon item 1.

I was wondering if there was a VB solution?


Thanks in advance,


-CL

 

[ImkeF]

Hi CL,
Non-VBA-Workaround would be to fake it:
Create a slicer (“Group”) that looks just like yours, but where with every value that’s not “1” actually 2 lines are selected: The one that says it does plus “1”.

You need to create an additional table for that, based on a copy of your original table with an additional column (“Group”) to be filled with ID from the existing lines. Then you add as much new lines as there are “non-1”-lines in your dataset with: [ID] for "1", but [Group] as the one of the non-1 lines: one each. (Of course, this can be done fully automatic & dynamic in PowerQuery, so no need to manually interfere at all, once it's set up

You need to connect that table with your original table via ID Masterdata-table (your bridge table). This will give a m2m-relation, which means you need to wrap your existing measures into:
Calculate([Measure], IDMaster, Group)

Well at the end you might consider redesigning your report in order to avoid this hassle, but it’s an option

Re VB-solution, you might be better off in the main Excel-forum.