Power BI waterfall charts provide a great way for users to visualise how pieces of an overall plan (or results) are combined to contribute to an outcome. For example, you could use a waterfall chart to show how sales have increased by year and category as illustrated below using the […]
There was a very subtle but important change made in the April 2020 release of Power BI Desktop that you may have missed. Take a look in the format pane on the right in the image below – do you see it? Note the “new” function buttons? When I say […]
Have you ever had report consumers that just don’t read your instructions? Well, you’re not alone. Having delivered our Module 1 : Data to Dashboard training for about 4 months now, I have often been challenged during the Drill Through Reports topic, with students commenting “I’ve tried text based tooltips […]
Tabular Editor is a community Open Source software project written by Daniel Otykier. I have known about this product for several years but never really invested the time to understand what it does and how it can help me do my job. Last week I attended the Microsoft Virtual MVP […]
As most readers of my website would surely know, Microsoft Excel has had a dual axis line chart as a standard charting visual for many many (many) years. A dual axis line chart is needed when you have 2 sets of data to display with significantly different scales like the […]
Back in 2018 I wrote an article showing how to extract data from websites using Power Query in Excel. For simple websites this process is very straightforward. For more complex websites the process is not always that easy. Microsoft is working on improving the “from web” experience and is building […]
Last week I held a free Power BI webinar for people starting out with Power BI who are wondering why they should invest time in learning about DAX. I had more than 700 people register and was completely overwhelmed by the response. There were a few questions that I didn’t […]
UPDATE: Below is a registration link for access to the Webinar. On 2 October I will be hosting a free webinar called “Introduction to DAX for Power BI”. I have trained literally thousands of people on the DAX language through my books, online training and live training. But everyone is […]
Last week I attended Summit Australia in Melbourne. Summit Australia is a conference that focuses on the same products as the larger Microsoft Business Applications Summit (held this year in Atlanta). The majority of delegates visiting the Summit this year were interested in Microsoft Dynamics, but there was also a […]
One common requirement I have come across a few times is to limit a Power BI visual to only show completed months and exclude the current active month. This is common if you load data on a daily basis, but some of your reporting is done on a monthly basis. […]
It is very common to need to transform data from one “shape” to another “shape” before it can be used inside Power BI for analysis (although many beginners don’t realise this). One such example is shown below, where the data in the table on the left hand side needs to […]
I blogged about the various ways to use Measure tables and Measure Sub Folders in Power BI a few weeks back. I discussed why measure tables may be required, and also a few reasons why you may choose not to use a measure table. I also mentioned some alternatives to using […]
I often get asked about how to create measure tables during my Power BI course classes. This post will discuss the merits of measure tables versus storing your measures in the table where the data comes from. What is a Measure Table? A measure table is a dedicated table used […]
Way back in Oct-2016, Microsoft released a feature in Power BI Desktop that makes the process of creating groups much easier for the average user. I was reminded of this feature by an article by Reid Havens a couple of months ago. I blogged about various other ways of doing […]
One of the things I like about my live, online training courses is that I get to hear great questions from the trenches from people learning DAX and Power BI. Last week, John asked me how to apply conditional formatting with a Text field (not a numeric field). I knew […]
I was answering a question for a student in one of my online training courses this week. The question was, “Do you know of a way in power query to efficiently extract YYYY-MM from a Date column?” This can be done ‘manually’ with multiple steps including: Extract the Year into […]
Updated Feb 2019. This is an edited version of my original article which first appeared on my site in Feb 2016. The rate of change in the tools available to a Business Analyst has never been faster than it is today. The market is changing so quickly that many Business […]
Note: This is copied onto the original Post – How and Where to Get Help for Power BI Level: Beginners/Intermediate Regardless of what stage you are at in your Power BI/Power Pivot/Power Query journey, at some stage you are going to need some help. Believe me I am no different to […]
Level: Beginners/Intermediate (originally posted 2015, updated 2017, 2018, 2022). This article is one of the most frequently read on my blog site and I wanted to update it to continue to improve the value people get from my site. Even if you have read this article before, why not take […]
It’s pretty early in the morning here in Sydney Australia (just after 6 am actually). I just finished a fun YouTube session with Avi Singh where I demonstrated my approach to using variables in DAX to help write more complex formulas. Avi streamed the session live on YouTube, and it […]
Excelerator BI | © 2023 | Sitemap