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...] Infos zum Plugin Change axis and measure in a visual by clicking a slicer
Wir lieben Microsoft Power BI
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.
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...] Infos zum Plugin Change axis and measure in a visual by clicking a slicer
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, …
Technical Topics (english), Tools /
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...] Infos zum Plugin How to speed up metadata translations in Power BI
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...] Infos zum Plugin Let your users know how up-to-date their data is
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 …
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...] Infos zum Plugin 3 ways for sums over columns in Power Query
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...] Infos zum Plugin How to handle custom errors in M gracefully
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...] Infos zum Plugin How does the filter context in DAX apply?
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...] Infos zum Plugin Table.Profile and its unknown second parameter
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...] Infos zum Plugin Tables in Power Query – how, when and why
THE SELF-SERVICE-BI BLOG
Mail: lars@ssbi-blog.de