cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
det55 Frequent Visitor
Frequent Visitor

Compare two sets of data

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.  

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
det55 Frequent Visitor
Frequent Visitor

Re: Compare two data points

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.

5 REPLIES 5
Highlighted
det55 Frequent Visitor
Frequent Visitor

Compare two data points

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.  

 

 

Super User
Super User

Re: Compare two sets of data

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


det55 Frequent Visitor
Frequent Visitor

Re: Compare two sets of data

 

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

 

 MonthUnitsRevenueProfitProductRegion
JoeJan10206JeansNorth
JoeJan10206JeansSouth
JoeJan12248ShirtsNorth
JoeJan12248ShirtsSouth
JoeSep12248JeansNorth
JoeSep12248JeansSouth
JoeSep12248ShirtsNorth
JoeSep12248ShirtsSouth
SamJan10206JeansNorth
SamJan10206JeansSouth
SamJan12248ShirtsNorth
SamJan12248ShirtsSouth
SamSep15156ShirtsNorth
SamSep15156ShirtsSouth
SamSep12248JeansNorth
SamSep12248JeansSouth
Super User
Super User

Re: Compare two sets of data

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.

det55 Frequent Visitor
Frequent Visitor

Re: Compare two data points

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.