Microsoft has released the "field parameters" feature in the latest Power BI Desktop. This allows the user to change the measures OR dimensions of a visual …
[Weiterlesen...] ÜberChange axis and measure in a visual by clicking a slicer
Technical Topics
While all the other posts on this blog are in German, the Technical Topics are my way to contribute to the international Power BI community. The intention is to help others with these great tools and to learn myself from getting your comments. Enjoy.
Loading multivalued fields from Microsoft Access – not possible with Power Query
Unlike most of my articles, this one doesn't solve a problem, it highlights one. If you use Microsoft Access as a data source to import data via Power Query, …
How to speed up metadata translations in Power BI
At the time of writing, the Power BI service supports 44 different languages. In this article I will show you how you can significantly reduce the effort to …
[Weiterlesen...] ÜberHow to speed up metadata translations in Power BI
Let your users know how up-to-date their data is
Before an analyst can start analyzing the data, first it is necessary to know whether the data is up-to-date or not. There are (at least) two pieces of …
[Weiterlesen...] ÜberLet your users know how up-to-date their data is
Fast table construction with Table.FromColumns and lists with metadata records
One of the fastest methods I know to create tables in Power Query/ M is the function Table.FromColumns(), which takes a list of lists and creates a table from …
[Weiterlesen...] ÜberFast table construction with Table.FromColumns and lists with metadata records
3 ways for sums over columns in Power Query
Normally I calculate sums in Power Query over rows. Recently, however, I was given the task of calculating sums over columns. I wrote a German-language post …
[Weiterlesen...] Über3 ways for sums over columns in Power Query
How to handle custom errors in M gracefully
I can recall that back then, in the good old Excel VBA days, at some point, I was very busy with error handling to make it easier for the user to understand the …
[Weiterlesen...] ÜberHow to handle custom errors in M gracefully
How does the filter context in DAX apply?
If you deal with Time Intelligence functions (TI) in DAX, you quickly reach the point where you can no longer use the standard TI functions. Very quickly you …
[Weiterlesen...] ÜberHow does the filter context in DAX apply?
Table.Profile and its unknown second parameter
A couple of weeks ago I could finally publish my post about tables in M - how, when and why. Under "Other special table functions" I mentioned the function …
[Weiterlesen...] ÜberTable.Profile and its unknown second parameter
Tables in Power Query – how, when and why
The M language has so-called structured values, to which lists, records and tables belong. Each value type serves specific purposes and this post is intended to …
[Weiterlesen...] ÜberTables in Power Query – how, when and why