Forum Discussion
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
- det55Regular 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.
- det55Regular 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.
- Greg_Deckler
Community Champion
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
- det55Regular Visitor
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
- Ashish_Mathur
Super User
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.