Data Culture: Training for the Community of Practice
The last few posts and videos in this series have introduced the importance of a community where your data culture can grow, and ways to help motivate members of the community, so your data culture…
Using calculation groups to selectively replace measures in DAX expressions - SQLBI
This article describes how to use calculation groups to dynamically replace only a partial expression in a complex DAX calculation. This article contains a
Install Power BI Helper as an External Tool for Power BI
The news about Power BI external tools have gone viral on the internet, and every day we see many useful tools added under external tools. The good news for those of you who have been waiting is that you can now have Power BI Helper also (even though a bit late in the game) to…
In this article, I’m going to show how you can use Visual Studio Code to run queries against a Power BI model. Usually, this is the kind of task you would use the excellent DAX Studio for, bu…
Simplifying enterprise data discovery and analysis in Microsoft Excel
We know that Excel is one of the most widely used tools in the world for understanding data and making decisions based on that data. It's used by hundreds of millions of users each month in almost every type of company imaginable. To better meet the needs of our users, Excel has evolved and transfor...
I recently published my color contrast report in the Power BI Data Stories Gallery. It allows you to enter two hex color values and then see the color contrast ratio and get advice on how the two c…
[vc_row][vc_column width="1/1"][vc_single_image media="87927" media_width_percent="100"][vc_column_text] Complete blog post to be released following the 4th part of the series. Part 3 Power […]
Power BI Sidetools is a free Power BI external tool intended to increase productivity during reports development in Power BI desktop. Transfer DAX and M formulas to files With just one click, you can transfer M and DAX formulas into a folder named like your report. The very first use case wil...
Power BI visual customization – using perspectives
Back in May 2020, I wrote a blogpost about visual customization in Power BI reports. The feature was released in preview with the April 2020 release. Now, the Power BI team made another update to t…
The last two videos in our series on building a data culture covered different aspects of how business and IT stakeholders can partner and collaborate to achieve the goals of the data culture. On…
This article describes how to create Key Performance Indicators (KPI) in a Power BI Desktop data model by using Tabular Editor. Starting from the July 2020
BI Polar has a series of videos and accompanying blog posts that focus on key aspects building a data culture. This series is in progress – five videos have been published so far, and more vi…
Doing Power BI the Right Way: 1. Futureproofing Power BI solutions
When starting a Power BI project, you have many choices to make. Decisions like how to source your data, where and how to create queries to cleanse, transform and reshape the data; where and how to…
Chris Webb's BI Blog: The Pros And Cons Of Modelling Measures As A Dimension In Power BI
You probably know that dimensional modelling and building a star schema are very important in Power BI. In a star schema you’ll have at least one fact table, and in your fact table you’…
These days more and more data lives behind an API, rather than in a more traditional data source like databases or files. These APIs are often designed and optimized for small, chatty[1] interactio…
Exam DA-100: Analyzing Data with Microsoft Power BI
Microsoft released the exam DA-100 (Analyzing Data with Microsoft Power BI) around early April 2020 which was in Beta until around the beginning of July. After the exam become out of Beta, I was wo…
Generating Row Number in Power BI Visualization Using DAX
I have previously explained how to generate a row-number using Power Query. That method is good for pre-calculating row-numbers in the table. However, sometimes, you want to calculate the row number in a visual, based on something dynamic. That is where DAX comes handy. Let's see how this is possible. Sample model I have a…
Power BI Modeling Tip: Snapshot Table, or DAX Measures?
I often get this question: "Is it better that I create this calculation as a snapshot table in Power Query (or T-SQL, or the data source), or write DAX measures for it?" If you ever had a scenario of creating a report of snapshots, you know what I mean. "Should I have a table for…