Compare two sets of data

[det55]

Hi;

  I'm fairly new to Power BI, so in addition to solving my exact question I wouldn't mind being pointed to examples of similar problems.

What I would like to do is be able to compare select attributes from two different selections next to each other, and then further show the difference.  For example, if I have a data set that was similar to so many of the examples that I have seem (they all seem to use sales data over time) I would like to be able to select from two different sets of filters to compare Units/Revenue/Profit/etc. from one Time Period/Sales Person/Category to another. See rough example of the type of output I'd like below. Each column would be controlled by a set of three slicers.  Thanks in advance for your help!

                      January/Joe/Jeans                September/Sam/Shirts            Difference 

Units                          20                                          30                                  +10

Revenue                     40                                          30                                  -10

Profit                          12                                          12                                  +0

After I get there, I'd like to be able to put together a waterfall chart that would use calculated metrics to walk from Profit to Profit in buckets such as Volume, Revenue/unit, Profit/Revenue, etc.  

[Ashish_Mathur]

Hi,

In the same visual, I do not think you can have multiple slicers work on different columns i.e. the Month for one column should be September and for another it should be October in the same visual.  You will have to create 3 seperate visuals i believe.

[Greg_Deckler]

Sample output is great, but sample input data as well would be even better. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[det55]

This is a sample of input data.  I highlight the data the slicers for my output example pull from.

	Month	Units	Revenue	Profit	Product	Region
Joe	Jan	10	20	6	Jeans	North
Joe	Jan	10	20	6	Jeans	South
Joe	Jan	12	24	8	Shirts	North
Joe	Jan	12	24	8	Shirts	South
Joe	Sep	12	24	8	Jeans	North
Joe	Sep	12	24	8	Jeans	South
Joe	Sep	12	24	8	Shirts	North
Joe	Sep	12	24	8	Shirts	South
Sam	Jan	10	20	6	Jeans	North
Sam	Jan	10	20	6	Jeans	South
Sam	Jan	12	24	8	Shirts	North
Sam	Jan	12	24	8	Shirts	South
Sam	Sep	15	15	6	Shirts	North
Sam	Sep	15	15	6	Shirts	South
Sam	Sep	12	24	8	Jeans	North
Sam	Sep	12	24	8	Jeans	South

[det55]

Hi;

  I'm fairly new to Power BI, so in addition to solving my exact question I wouldn't mind being pointed to examples of similar problems.

What I would like to do is be able to compare select attributes from two different selections next to each other, and then further show the difference.  For example, if I have a data set that was similar to so many of the examples that I have seem (they all seem to use sales data over time) I would like to be able to select from two different sets of filters to compare Units/Revenue/Profit/etc. from one Time Period/Sales Person/Category to another. See rough example of the type of output I'd like below. Each column would be controlled by a set of three slicers.  Thanks in advance for your help!

                      January/Joe/Jeans                September/Sam/Shirts            Difference 

Units                          20                                          30                                  +10

Revenue                     40                                          30                                  -10

Profit                          12                                          12                                  +0

After I get there, I'd like to be able to put together a waterfall chart that would use calculated metrics to walk from Profit to Profit in buckets such as Volume, Revenue/unit, Profit/Revenue, etc.  

[det55 · Accepted solution]

I created my own solution of creating a "reference" table that is identical to the first.  I can then build filters on either table and create measures to compare them.