Compare Any Two of Anything in Power BI - Excelerator BI

Compare Any Two of Anything in Power BI

I have been increasingly recording videos as my method of sharing tips and techniques for getting more out of Power BI. Some concepts are best documented (traditional blogging) and some are just easier for everyone if it is a video. That is the case again for today.

Compare Any Two of Anything in Power BI

The whole concept here is to allow a user to pick two things from a list and compare them with each other. For example, compare

  • Any year with any other year
  • Any product against any other product (maybe even a group of products, using multi select)
  • Snapshots (eg different versions of a financial forecast) with any other version
  • Etc

What is possible is endless, and the good news is that it is pretty simple to do this in Power BI. Check out my video below to see how I did it.

Final Result

You can see in the image below, the user can select a year from the top slicer and any other year from the bottom slicer, and the visual updates along with the title of the visual clearly communicating what is being displayed.

Compare Any 2 Of Anything

If you would like to learn more about Power BI from experts like me, Ken Puls, Miguel Escobar, and Reid Havens (all Microsoft MVPs), head over to http://skillwave.training and check out our training course catalogue. Yes, you can learn yourself using YouTube – there is a lot of great free content out there (like my video below), but you will learn better/faster if you take a structured course built by industry professionals.

Video

10 thoughts on “Compare Any Two of Anything in Power BI”

  1. Wonderful :). Then the next question is… how to filter comparison slicer so it doesn’t show selected items from non-comparison slicer?

  2. Very concise and clear explanation.
    Sometimes we come across people who clearly know a lot about a certain subject but cannot explain it in a simple way, which is not the case with Matt Allington.
    Thank you.
    JM

  3. You made it look so easy! Thanks for that

    On a side note, your Power BI runs really smoothly. I find mine can be really choppy and lags a lot. I experience this on both my work and personal machine, each with 8GB ram. Is that insufficient for Power BI ?

    1. Sometimes I edit out the spinning wheel so you don’t have to wait for Power BI to update. 8GB is the minimum and should be fine unless you have 10’s of millions of rows of data.

  4. Hey Matt, some of us poor souls have an IT department that restricts access to YouTube etc. …any chance you could provide both the video and a more traditional blog for your solutions?

    1. Hey Mat. I sympathise for you. Companies that don’t allow access to YouTube are dinosaurs. I say companies and not IT, because the IT department is only as good as the leadership of the company. Read my article about that here https://p3adaptive.com/2016/10/company-suffer-battered-syndrome/

      While I would like to help, it takes 2-4 hours to produce either a video or a blog, and I don’t have the extra time to do both. Time for you to start lobbying your company for a more progressive approach to IT 🙁

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top