Forum Discussion

det55's avatar
det55
Regular Visitor
8 years ago
Solved

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.  

 

 

  • 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

  • det55's avatar
    det55
    Regular Visitor

    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's avatar
      det55
      Regular Visitor

      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.

    • det55's avatar
      det55
      Regular Visitor

       

      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
  • 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.