Select Page

Items NOT Selected in a Slicer?

I recently attend a school reunion (class of 1981 for what it’s worth – wow, I’m old!).  We all had a great time catching up, looking at old photos, taking new photos etc – how things have changed!  Anyway that got me thinking that it would be great to do something...

Changing Defaults in Power BI

Changing Defaults In March 2017, the Power BI team delivered a new feature that allowed you to change the colour defaults in a Power BI report using a custom colour theme.   I wrote a blog post over at PowerPivotPro.com at the time.   The drawback of this feature, as...

EARLIER vs EARLIEST in DAX

Level: Advanced The EARLIER() and EARLIEST() functions are 2 of the harder functions in DAX to get your head around. If you come from a programming background it will probably be easy for you.  However as I have repeatedly stated on my blog, one of the many great...

Sales of Same Products to Other Customers

Level: Intermediate I was helping someone on a forum recently and I thought the question and solution would make an interesting blog article. I have adapted the scenario to work with Adventure Works customer purchases, but this concept would work equally well across...

Lineage in DAX

Level: Intermediate–Advanced I have covered the topic of Lineage in DAX a few times in the past (within other articles).  Today I thought I would write a single post dedicated to lineage. As you may know, Power BI has a number of different operation modes, some of...