Forum Discussion
Compare two sets of data
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.
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.