Power BI

I just tested the technique shared by Ruth from Curbal, using the smart narrative to do storytelling in Power BI in order to to catch the user's attention and deliver insights more effectively. The goal is to highlight the selected categories. In a bar chart it's easy since it includes conditional formatting allowing to do it flexibly.

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 [...]Read More »

Azure Maps is a Microsoft technology that has a lot of cool features. Somewhat unexpectedly I discovered that along with purely mapping stuff it also provides functionality to acquire weather forec…

This blog post shows you how to change the filtering options from two items to multiple items in your Power BI reports.

A step by step guide to implement a paired t-test in Power BI using DAX only

Data Masking for Sensitive values

Transforming multiple columns at once with reference to existing columns can leave you with very slow queries. Learn how to do this fast.

Azure Data Explorer has a data type called dynamic which can be used to hold scalar values as well as arrays and property bags; you can read about it in the docs here. For example (following on fro…

In this short video blog we walk through how to create custom basemaps in MapBox and integrate them into your Icon Map in Power BI! We then take it to the next level by configuring dynamic basemaps which we can change using slicers. A big shoutout and thanks to James Dales for creating this awesome

With Power Query we can get the Date and Time of the last refresh, or the date modified. This post will show you how.

Let's see how to create your own data types in Power BI! This is a follow up of Part 1, where we learned how it's done in Power Query.

Turn ON and OFF tooltips with a button in Power BI Reports

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 [...]Read More »

OR logic in DAX is frequently used in various Power BI calculations. The bad and the good news is that you can create that in multiple ways.

Do you think Microsoft's files always follow best practices? In this episode, I'm dissecting a DAX formula from an automatically generated Power BI file.

Basically for every data model, but in particular for large and enterprise-grade data models, it might be wishful to perform backups. Power BI Premium offers a way to perform backup and restore ope…

My favourite – and it seems many other people’s favourite – new feature in the February 2022 Power BI Desktop release is support for more datasources (including SQL Server, Azure …

The Mastering DAX Workshop is the most advanced course available on the DAX query language, bringing our students to a whole new level of expertise.

Part of the the series: Doing Power BI the Right Way When you sign-up for the Power BI service at PowerBI.com (this address redirects to App.PowerBI.com), use establish a tenant for your organ…

If you are designing solutions with Power BI, or using Power BI along with other data platform components, to be used in a large organization; how should you get started and what are the best pract…

Most organizations have resources locked behind a firewall of some sort regardless of whether the data is on the cloud or on-premises. When it comes to processing data into Analysis Services, this …

If your Power BI dataset needs to connect to an on-premises data source it will need to connect via an On-Premises Data Gateway; what’s more, if you have a Power Query query that combines dat…

When I began my software career back in the 90s, one of the software-adjacent skills I discovered I needed was risk management. When you’re building anything non-trivial, it’s likely th…

My last post focused primarily on a problem that can arise when there’s a central team that sits between a team responsible for delivering solutions, and teams that have problems to be solved…

In this video, I’m going to show you how to make a very attractive in-page navigation in Power BI using BOOKMARK NAVIGATOR. Follow the steps and let’s learn how to make this awesome feature.   ExcelFort - YouTube     Hope this article/video was helpful to you? Please leave your comments, suggestion...

This article provides the best practice to use ADDCOLUMNS and SUMMARIZE, two functions that can be used in any DAX expression, including measures. UPDATE 20

No-Code Partner Innovation for End-User Self-Service inside Power BI