Create a Slicer based on data from 2 columns

[Anonymous]

Hello All,

I would like to create a slicer which will be based on 2 columns. For example sample data and how the slicer should look like is shown below.

Sample data:

	Type A	Type B
Sydney	100	10
Tokyo	200	80
SF	300	20
NYC	230	20
LA	500	5

Slicer: will be based on columns "Type A" and "Type B" such that when I select "Type A" it will display the values for all the cities for type A. If I select "Type B" it should display values of cities for type B and if i select both "Type A" and "Type B" then it should sum the values. Scenarios outlined below:

Scenario 1: Type A selected

Slicer

Type A - selected

Type B

Table will display:

	Type
Sydney	100
Tokyo	200
SF	300
NYC	230
LA	500

Scenario 2: Same  as scenario 1 when type B is  selected.

Scenario 3: when both Type A and Type B are selected

Slicer

Type A - selected

Type B - selected

Table shows:

	Type
Sydney	110
Tokyo	280
SF	320
NYC	250
LA	505

Thanks in advance!

[FrankAT · Accepted solution]

Hi @Anonymous ,

you can do it like this:

Take a look at the attached PBIX file.

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)