Background In the SQLBI article Understanding Group By Columns in Power BI, Marco Russo & Alberto Ferrari show how the Group By Columns property allows the values in one column to be “grouped by” unique key values defined by one or more other columns, rather than by the original column’s unique values. For example, setting…
On 23 May 2024, I had the pleasure of presenting a session titled Dissecting Field Parameters to Power BI Barcelona User Group. Thank you Bernat Agulló for inviting me! In this post I wanted to post a quickfire list of the key points I presented! 😊 The PBIX containing the examples is here: 1. Simplest…
If you have ever created a Power BI report with live connection to an Analysis Services Tabular model (SQL Server Analysis Services or Azure Analysis Services), you might have wondered if it is possible to use field parameters in such a report. The answer is yes! The main point to remember is that field parameters…
Have you ever wanted a slicer or filter in your Power BI report to select the most recent date by default (or something similar) when it is opened? In my experience this is quite a common request, and in this post I’ll share some solutions I’ve been experimenting with. Isn’t this already on Microsoft’s roadmap?…
Introduction In my previous post Creating alias columns for calculation groups I showed how to create alias columns containing alternate names for calculation items in a calculation group by using the Group By Columns property. To recap: By setting the Group By Columns property of any alias columns to be the original calculation item column,…
