Category: Power BI

Power BI Percent Of Total – Using CALCULATE Statement

Power BI percent of total is a really common calculation that we require quite often. This is great to quickly show where the larger portion of results sit versus the entire population. Completing this in Power BI does not require much written code, but it does require some understanding. It will generally be one of the

Continue reading

Solving the Power BI colours and themes issue…for now

Users of Power BI will quickly find one drawback to making compelling reports and dashboards, and it all has to do with colours! Unfortunately, the team at Microsoft have not quite yet worked out how to include themes into Power BI desktop and the online service. No doubt they will look to remedy this as

Continue reading

Formatting DAX Code In Power BI

Effort here will pay dividends later Placing effort into formatting your DAX code will make a huge difference as you build out your data models in Power BI. DAX, at times, is a confusing language, as it is. So as soon as you get into the slightly complex territory, unformatted DAX code becomes almost impossible to

Continue reading

What Is DAX Context Transition And Why Does It Matter?

One of the key concepts in DAX Context transition is one of the tougher concepts to know and understand well in the DAX language. Why do you even need to know it? Well, if you want to create calculations within calculated columns that reference columns from another table or if you want to run a

Continue reading

Why Power BI is very quickly going to get huge!

The growth opportunity for Power BI is massive I am basically convinced that Power BI is about to explode into the most used enterprise analytical tool around the world in no time. I’m imagining we are out the back of a set of waves, the crest has only just appeared on one, but it will

Continue reading