Categorize or Slicer of Slicers?

[Anonymous]

Is it possible to create custom categorizes that would toggle on certain slicers? A slicer of slicers per se?  The highlighted groups below are all part of the same team, but the data is split between 3 different databases.  AFAIK, slicers work with a name match - and I couldn't find a method to target certain items and categorize them together.  Ideally, I would expand this to create a custom category each team inside of the larger team, and be able to toggle between them all.

Thank you!

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Please create a calculated table as below and make it related to your fact tables to work around.

Union =
UNION (
    DISTINCT ( table1[Board_name] ),
    DISTINCT ( table2[SkillGroupName] ),
    DISTINCT ( table3[FullName] )
)

If it doesn't meet your requirement,  kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[amitchandak]

Refer, if this can help

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

[Anonymous]

I saw that KB before, however the data is not shown under one visual - we're running trends across the entire 'group' so it only comes back with values.  There are multiple trends being shown across the board and I'm hoping to be able to toggle on/off the 'groups' all at once.