A slicer to chosse among multiple filters

[howdy123]

Howdy there,

I spent most of my afternoon trying to resolve this problem. I read a lot on the Internet, but much didn't make sense to me.

Let me expose you my problem. I have data that look like this :



I defined clusters in two formats (because I don't know which format to use !). The trick : a car can belong in several clusters.








I'd like to aggregate my COI according to those clusters. For that, I want to use a slicer :



If I click on a cluster, I want my pivot table to aggregate the COI for all the cars which respect this condition.


My data model looks like this right now :




I cannot connect Filters[Car] to Data[Car] because values in Filters[Car] are non-unique. I could do it with 'Filters - Possibility 2' though (see the different format above), but then I can't link it to my clusters (since there are several columns).



So how to pass my cluster ('Slicer field') to my data ? Is there a way to do this usingPowerPivot, without adding one column for each cluster at the end of my data, like I'd do with Excel ?

Could you also inform if this 'notion'/problem got a name, so I can search on Google more efficiently ?


Thank you very much !

Have a nice day.

 

[scottsen]

This feels at least similar to this: Dynamically changing chart axis | Power Pivot | Tiny Lizard

Hopefully that helps.

 

[howdy123]

This feels at least similar to this: Dynamically changing chart axis | Power Pivot | Tiny Lizard

Hopefully that helps.

I tried all the examples and then managed to do mine. It works like a charm. Thanks !