Calculating difference in data between two slicers and plotting stacked bar chart

[needtoknow]

I have a table that looks like this:

Location	Day	Product_Name	Quantity
East	1	Apples	10
East	1	Oranges	8
West	1	Apples	15
West	1	Oranges	5
North	1	Apples	12
East	2	Apples	8
East	2	Oranges	12
West	2	Apples	7
West	2	Oranges	8
North	1	Apples	10

I would like to get the difference in quantities for each Day and Product_Name between two Locations that are selected in slicers i.e:

Slicer 1 (Location): East

Slicer 2 (Location): West

The output desired would have the values of Slicer 1 minus Slicer 2 (East minus West) like the table below but in the form of a stacked bar chart with Day on the x-axis, Difference in the y-axis and Product_Name as the stacked categories.

Day	Product_Name	Difference
1	Apples	-5
1	Oranges	3
2	Apples	1
2	Oranges	4

[amitchandak · Accepted solution]

@needtoknow , My video on similar topic can help

Power BI- Compare Categorical Data Using Slicers, Compare Two Brands/Categories/Cities: https://youtu.be/exN4nTewgbc

[needtoknow]

Perfect! Thank you @amitchandak.