You may already be aware (but then again, maybe not) that Microsoft shares its plans for upcoming new features for the Power Platform every 6 months, and Power BI forms a subset of that plan. The next plan is called Power Platform Release Plan 2021 Wave 2. It takes a […]
Today is another in my series where I am building out my COVID report for Australia. There are a few things I cover in the video today. The main “new” concept is the dynamic commentary, but I also show you some more warts and all insider view of building a […]
I have a very simple video today with not a lot of DAX needed; I just want to demonstrate how you can gain insights from data. On 10th Sept 2021, NSW health made a material change to the Active Cases reported for COVID-19 in Australia (as you can see in […]
Ken Puls and I decided we would do a live stream chat to talk about a topic of interest to Power BI people. We put out a survey and 75% of the respondents wanted to hear about “when to use Power Query/M vs Data Modelling/DAX”. It’s a really interesting topic […]
Earlier this week I did a live stream event. I put out a poll and asked people to tell me what topic they wanted me to talk about. The options were Calculated Columns vs Measures Tips for Excel users moving to Power BI Using Variables in your DAX The overwhelming […]
In my video today, I continue to build out my Power BI Covid Australia report. I wanted to overlay 2 phases of time on a single chart, as shown below. There were a few things I needed to do to make this work, including writing some time intelligence to get […]
Today I am sharing another of those videos where I show you how I have built out my COVID report for Australia http://xbi.com.au/ca The live report is running a few weeks ahead of my blog videos, so that is why you will see features in the live report that I […]
This is not the first time I have shared this concept. In my previous article I showed how it is possible to add a prefix to every column in a table. This article today is slightly different. Today I am removing text from multiple columns all at once using some […]
Every now and then I write an off-topic blog post; today is one of those days. In the past I have shared how I manage my time, in case you are interested in going back and reading that one. Today I want to give you some motivation to save well […]
I was inspired into action this week by one of the worst visuals I have seen during the COVID pandemic. Here is the visual below, take a look and see what you think. When I first saw this chart, I simply couldn’t make sense of it. The first thing I […]
This article continues to build on my COVID Case Fatality Rate report for Australia. Something happened with the global source data this week – in short, it was wrong. This is a global database and I am sure there are many people diligently trying to keep the data up to […]
As is almost always the case when building Power BI reports, the first version is just the start of the journey, not the final destination. This article is a follow up from last week where I showed you how I built my COVID Power BI report from scratch. This week […]
As promised, today I am sharing with you the process I went through to build the COVID report I shared in my last article. One of the best ways to learn and improve your Power BI skills is to practice. The best way to practice is to find something you […]
I am writing an off-topic article today but I promise I will circle back later in the week with a follow up article bringing it back on topic. In this article, I am going to share a COVID report I built today, and later in the week I will post […]
This is a follow up article from my last blog post where I demonstrated how easy it is to use two slicers to compare any two items. In the demo in my article, I specifically showed how you could compare any 2 years of choice, but the principle applies to […]
I have been increasingly recording videos as my method of sharing tips and techniques for getting more out of Power BI. Some concepts are best documented (traditional blogging) and some are just easier for everyone if it is a video. That is the case again for today. Compare Any Two […]
I was helping someone recently with an issue. They wanted to allow end users (department managers in this case) to enter data in a table as simply as possible, and then use this data for reporting. The challenge often is, that the easiest way to enter data from a user’s […]
Tabular Editor is a Power BI Tabular Modelling productivity tool developed by Daniel Otykier. I blogged about Version 2 of the Tabular Editor in this article here. The 3rd edition of Tabular Editor has just been released, and it is a major upgrade from version 2. TE 3 is not […]
This is the third article where I have covered building a P&L in Power BI. My first 2 articles here and here focused on how to use the DAX language to solve some of the common problems with P&L reporting, such as adding sub totals into the visual, % of […]
I first wrote this article back in Feb 2017 to be a definitive list of the top reasons why you should learn how to use Power BI in your organization (in case you haven’t already made the decision to do so). In fact there is only one thing that worries […]
Excelerator BI | © 2023 | Sitemap