Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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 , My video on similar topic can help
Power BI- Compare Categorical Data Using Slicers, Compare Two Brands/Categories/Cities: https://youtu.be/exN4nTewgbc
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |