Category: Data Visualization

Compare Performance vs Forecasts Cumulatively w/DAX

Showcasing results cumulatively is, in my opinion, the best way to showcase trends in your data. When comparing data versus budget or forecasts, showing the trends or divergence in trend is essential. You want to make sure you can identify when your performance is breaking down as soon as possible and by viewing this cumulatively

Continue reading

Adding Commentary to Your Reports in a Dynamic Way

This idea came up purely from a client requirement, and by implementing it I thought wow, this actually has many applications. It’s also not that difficult to implement in Power BI. I know this happens everywhere in organizations, so I’m sure you can relate, but have you ever created a PowerPoint presentation and then had

Continue reading

Enterprise DNA Learning Summit – November 2017

Big annoucement this week! The first Enterprise DNA Learning Summit will be held through the middle of November (which is next week). You can find all details and registration here at this link – Enterprise DNA Learning Summit I’ve received plenty of feedback over the last few months around the webinar series that I’ve been

Continue reading

Tracking & Showcasing Trends In Power BI using DAX

Showing trends and how they change over time can add a lot of value to your consumers and decision makers. In this example I show you how you can use the conditional formatting inside Power BI tables to showcase this type of insight really well. Obviously to show growth trends we actually need to calculate

Continue reading