Tag: Power BI

Creating Multi Threaded Dynamic Visuals – Advanced Power BI Technique

In this post, I want to show you what is without a doubt one of the most compelling visualisation techniques in Power BI. Never feel you are confined to use just the general visualisation options inside of Power BI (or custom visuals for that matter). You have a significant opportunity to make your visuals even

Continue reading

Dynamically Compare And Calculate Difference Between This Year & Last Year In Power BI Using DAX

If you want to start creating compelling reports with strong insights into information over time, then you’ve got to know how to use all the variations of time intelligence functions. Some are easy, but others are much more advanced and can be difficult to use. In this post though, I want to take you back

Continue reading

ALL Function in Power BI – How To Use It With DAX

The ALL function is an extremely important part of the DAX language in Power BI. It can be used in a number of different ways within formulas that allow you to calculate results seamlessly when combined with the filtering available in the data model. Simply put, the ALL function can remove any context that is

Continue reading

Compare Cumulative Results For Multiple Months

Showcasing your results cumulatively is such a powerful way to visualize your data over time, especially if you are trying to show the difference in performance from one time period to another. When you try to present this at a daily or even monthly level, identifying the trend isn’t always so obvious. When you place

Continue reading

Expanding On Financial Reporting Templates, Next Enterprise DNA Member-Only Event

This week we will have the next scenario-method event from Enterprise DNA. These particular workshop sessions are for enterprise DNA members only. If you are a member and want to find out more about this particular event and register you can at this link below. Expanding On Financial Reporting Templates – September 2018 I’m really

Continue reading