Back in 2016, I created this idea at ideas.powerbi.com. I wanted to be able to have 2 different number formats in the same column in Power BI. This is particularly useful for things like a P&L report, but it is also useful for other types of reports. Doing this in […]
I have been waiting for this feature to be delivered for a while. Until this week, the only way to export data from Power BI was to do it into a source data table. That meant that if you had data laid out like shown below, and you exported it […]
I mentioned in an earlier blog that I have been doing some work with the owner of the InfoRiver Power BI Custom visual. I have been testing, given UI feedback, and more recently I have produced some instructional videos. I wanted to share the first of these videos with you […]
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 […]
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 […]
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 […]
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 […]
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 […]
A client recently asked me if it was possible to build a Power BI report using data from a Microsoft Form. I have come across this question a few times now, and you could be excused for thinking this would be a straightforward task. Despite the fact that Microsoft has […]
I blogged about how to Build a P&L With Power BI back in April 2020, and the response from my readers was great. Several people asked how to add percentages such as % of net sales revenue, % gross profit, etc. into the P&L. I decided therefore to do a […]
Power BI Desktop is a free, standalone self service BI tool for data modelling and reporting. You will not get a better, free desktop data modelling and reporting tool than this anywhere. Power BI Desktop is evolving at a rapid rate with updates released every month. Due to the […]
Level: Beginners First posted May 2015, Updated Feb 2021. Many aspects of this article also apply to Power Pivot for Excel. Technically you don’t need calendar tables to use Power BI. Power BI comes with an inbuilt date capability called “Auto Time Intelligence”. But the inbuilt capability is very basic, […]
Excelerator BI | © 2023 | Sitemap