Scenario Testing with Visuals / Slicers

[TotunG]

Hi All,

Not sure if this is possible but I basically have a table with items that have a cost on a particular date:

ITEM	COST	DATE
Apple	500	07/02/22
Banana	1000	14/02/22
Apple	200	14/02/22
Banana	1212	07/02/22
Carrot	412	06/02/22

So an example of what I would like to do would be to select some items (like Apple/Banana) and select corresponding dates (Apple - 07/02/22 and Banana - 14/02/22) which would then display the cost in a Matrix / Other Visual. So output for this example would be Apple - 07/02/22 = 200 & Banana - 14/02/22 = 1000, Total 1200. 

Any ideas on how this could be achieved? Seems difficult as I thought it could be done with a simple multi-select on the ITEM then a multi-select on the DATE slicer but this would then also give say Banana's 07/02/22 figure...

[amitchandak · Accepted solution]

@TotunG , put the Item and date in one slicer and create a hierarchical slicer and select date and item and use that