Display websites within Power BI dynamically
Recently, I had received several questions about whether you can view a website directly in Power BI. This can be implemented quite easily and is a good way to add more information to a report. However, one restriction must be mentioned in advance. Unfortunately, Power BI Desktop does not load web pages, so we will…
New notation for Date or DateTime format in Power BI
Quick update on the Power BI August 2021 release and this more, in case you encounter this new spelling and wonder what it is.As the title suggests, there is a new way to create a Date or DateTime value. If we consider the CALENDAR function as an example, then two values in the format Date…
Change formatting of each individual value dynamically with Calculation Groups
In September last year I had already written an article on how to dynamically adjust the values of a measure, for example in millions, thousands or without scaling: Dynamic scaling of a measure in Power BI with DAX The approach at that time with the FORMAT function had a big disadvantage, the value is always…
My Power BI and Power Query code snippets are moving to GitHub
Pretty much since I started the blog, I’ve been gradually sharing my code snippets for DAX and M here on the website. As the list got longer and longer and more and more confusing with all the examples, I decided to maintain and publish the code snippets on GitHub from now on. There I can…
Add a single value parameter for any column
Last week I had investigated why a what-if parameter sometimes skips values and how to bypass this. In a discussion with my valued friend Bernat Agulló, we came across the topic of single values in slicers and he directed me to a tweet on how to do this with Tabular Editor. Single values as slicer…