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