Category: Data Visualization

Showing Actual Results vs Targets Only To Last Sales Date In Power BI

Actual Vs Target To Last Sales Date Using DAX Cumulative Totals In Power BI

In this example, I want to show you how we can generate cumulative totals but only up to a certain point. A really relevant example if you are running some time comparison analysis and you’re looking at trends over time as a cumulative total in Power BI. Here’s a description of a specific scenario below.

Continue reading

Showcase The Top Result Name Within A Card Visualization Using Power BI

A recent question came out of the Enterprise DNA Support Forum where a member needed to work out what was the top value that they had for a particular result. You can review the entire forum post here – Product Name as Measure for Highest Sales Product They didn’t require just any value. They actually

Continue reading

Show Results Up To Current Date Or A Specific Date In Power BI

In this tutorial, I’m going to show you a very simple technique where you can show data up to a specific date or just up to today inside of your Power BI reports. This came from a recently requested question from the Enterprise DNA Support Forum, Personally, I’ve also used this technique many times so

Continue reading

How To Create Compelling Reports & Dashboards In Power BI

I decided to create a tutorial based on creating compelling reports and dashboards in Power BI. This is a general video around some of the ideas and techniques that I use to create reporting applications inside of Power BI. When completing development work with Power BI I attempt to not create elements in reports in

Continue reading

Using Great Color Schemes In Your Power BI Data Visualization

Using Great Color Schemes In Your Power BI Data Visualization

Creating a high-quality colour palette inside of Power BI is essential to making your reports look compelling and very professional. I’m constantly seeing reports out there which use the generic colour palette for Power BI, which to me is a huge negative. I personally can’t stand these colours as they just don’t do your work

Continue reading