Today I’m going to share my solution to a question I found on the MrExcel forum. It’s an interesting problem. https://www.mrexcel.com/board/threads/power-query-to-determine-consecutive-and-non-consecutive-dates.1261496/ Let me briefly explain the problem. The Problem We have the following table, which contains the source data. Each row contains a unique ID (maybe a piece of equipment) […]
Updated June 2024 We update this blog article regularly to keep track of how Microsoft is progressing on its strategic journey in building a world class BI platform. Gartner released the 2024 Magic Quadrant for Analytics and Business Intelligence Platforms in June. As expected (by us at least), Microsoft is […]
Level: Intermediate Why You May Want to use RLS Imagine you’ve just built a Power BI report filled with sensitive financial data. You want to start to share this data across the organisation but not everyone is allowed to see everything. The CFO should be allowed to see everything, but […]
Have you ever had a situation where you have a slicer selection that “sticks”? You make a selection in a slicer, then make some changes somewhere else, but the first selection you made “sticks” when it is no longer valid? Take a look at this animated demo below to see […]
Back in April 2022, I wrote an article called Poor Man’s Paginated Reports. That article covered an easy way to create a paginated report without having to learn how to use paginated report builder. Sometime since then, Microsoft has released the ability to create a simple paginate report online inside […]
I do a lot of Power BI model and report development; maybe you do too. There’s nothing worse than spending an hour or so developing your model only to have something go wrong and you lose your work. Things that can go wrong include: Your PC/App crashes. Power BI does […]
Microsoft has just announced the general availability (GA) of the integration of Power BI with PowerPoint. I have previously blogged about this feature here => Power BI Live Embedding. With the recent GA announcement comes a significant improvement over the public preview version. Power BI Single Visual Embedding in PowerPoint […]
I love the Power BI community. There are so many great things that the community does. They help each other (think the Power BI community forum) and they also build fabulous third party external tools to enhance Power BI. Measure Killer This week I am sharing a brand new third […]
This is the third in my series where I show how I build a report from scratch. The objective is to show the warts and all process that I go through. Along the journey, I am sharing some tips and tricks. In this video, I demonstrate Standardising the data across […]
This is a follow up to my previous article and video where I demonstrated how to download data from multiple web pages into a data model. In this second article in the series, I demonstrate what I would normally do at the next stage of building a report. I often […]
Every now and then when I have a Power BI project of interest to me, I like to create a video of the end to end process of building a new report. This allows me to share some “warts and all” real-world examples of how to go about building a […]
I first blogged about this back in October 2021 when Microsoft announced live Power BI embedding was coming to PowerPoint. Believe it or not, the ability to embed Power Pivot reports into PowerPoint was one of the first features delivered by Microsoft way back in 2014 or 2015. It used […]
I have many reasons for sharing content online. The main reasons are that I like sharing what I know, but also that I want to document how to complete a task for future reference. My article today ticks both of those boxes. How Many Employees by Period I’m calling this […]
The May 2022 version of Power BI Desktop includes a very interesting and useful feature – Field Parameters. Today I will show you how to use this new feature illustrating with 3 (no, wait, 4) use cases – Chart Elements, Chart Axis, Table Contents and Permanent Ad hoc Hierarchies. How […]
What?! Exploding Measures I hear you say. Exploding, expanding, use which ever word you like; what I mean is when you want to remove any refence to a measure INSIDE another measure. Example Consider the 3 measures below. Total Sales = SUM(Sales[ExtendedAmount]) Total All Product Sales = CALCULATE([Total Sales],ALL(Products)) % […]
Paginated Reports have been available in Power BI since 2019. They serve an important purpose, but they are not easy for the average business user to learn, plus they require Power BI Premium to use. In my blog and video today, I will show you how you can use Excel […]
I always tell people in my training classes that the best way to become good at using Power BI is to get plenty of practice. Best case scenario, you would do something at work that will help you succeed in your job and hence you will get paid to learn. […]
This is a further article in my series where I share with you what I have learnt about the InfoRiver custom visual. As good as Power BI is, it will take Microsoft many more years to make it fully featured. Microsoft Excel is 37 years old, and I can assure […]
At a recent training course, one of the students asked if it was possible to add two different columns on the legend of a line chart, so that when a selection is made on a second slicer the chart splits to reveal multiple lines. Given others in the class showed […]
I have written quite a few articles about Tabular Editor over the last few years. I recently started using Tabular Editor 3, and I absolutely love it. Buying this product is one of the easiest ways you can significantly improve your Power BI Data Modelling productivity. For US$100 per year […]
Excelerator BI | © 2023 | Sitemap