Forum Discussion
Calculating difference in data between two slicers and plotting stacked bar chart
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 |
needtoknow , My video on similar topic can help
Power BI- Compare Categorical Data Using Slicers, Compare Two Brands/Categories/Cities: https://youtu.be/exN4nTewgbc
2 Replies
- amitchandakSuper User
needtoknow , My video on similar topic can help
Power BI- Compare Categorical Data Using Slicers, Compare Two Brands/Categories/Cities: https://youtu.be/exN4nTewgbc
- needtoknowNew Member
Perfect! Thank you amitchandak.