Add grouping to display when selecting slicer item

[Anonymous]

Hi,

I have a scenario where I have a school slicer with options 'All' and 'Yes', the 'No' option will be excluded for selection.

For 'All' I want to display all schools which is working as expected but when 'Yes' is selected the user wants to display all schools with 'Yes' and also include those with 'No' in one large group/bucket as 'Other Schools'.  This will mean that the total will remain the same when you select 'All' or 'Yes'.  Does anyone know how I can achieve this?

The only solution I can think of at the moment is to create a reference table to achieve this but it would mean duplicating data between 'All' and 'Yes'.

Thanks,

Jen

[v-jiascu-msft · Accepted solution]

@Anonymous,

Hi Jen,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[v-jiascu-msft]

@Anonymous,

Hi Jen,

Using groups will work.

Best Regards!

Dale