Dynamic formatstrings with Calculation groups

One of the cool things of calculation groups is they cannot just be used to apply a calculation over your “base measure” but also apply a dynamic formatstring. You could do this without calculation groups before too as I described here. This method had one big drawback though, it uses the FORMAT function and when doing that all results are transformed into strings. This does help in showing the right format, but you lose a... Read more

Adding calculation groups to (A)AS or PBI Premium

I was playing around with calculation groups for a question. I found that adding a calculation group is not that straightforward as it should be, so I decided to blog about it to help you along. What are calculation groups? First let’s talk a little bit about calculation groups itself. Calculation groups is one of the most notable features for Tabular models in a long long time. In short it allows you to change measure... Read more

Get the SQL Query used in DirectQuery mode

When you are optimizing your DirectQuery model and you have done all the optimizations on the model already, you might want to run the queries generated by Power BI by your DBA. He then might be able to do some index tuning or even suggest some model changes. But how do you capture them? There are a few simple ways that I will describe here. 1 Use DAX studio and Power BI desktop We will... Read more

Show values in a chart only when a slicer is selected

Quick one today. This question came up recently: “I only want to show values in a chart when someone selected a slicer”. Now this is actually not that hard, so here is the trick (and a little bonus too). First I created a page I wanted it including the slicer: Now the next thing I want is that the values of the visual only show when I select a country. First thing I do is... Read more

5 reasons to use aggregations in Power BI

A lot has already been written on aggregations and it is one of the most exciting features of Power BI in a while. The guys at SQLBI did a session on it and my colleague Phil Seamark wrote an amazing host of articles with many details and tips and tricks on it. So why another article? Most people think aggregations is only applicable to petabyte scale data sets. That doesn’t have to be the true... Read more

Power BI and the year 2019 in review

As the end of the year closes I was reminiscing on what a huge year it has been for Power BI. I work mostly with large organisations so my view will be slightly skewed towards that. For me 2019 has been the year where Power BI got massive adoption as the standard BI platform in an organisation, it went from self serve to also contain corporate BI. These two pictures from one of Arun’s keynote... Read more

Building a dataculture with Power BI

I meet a lot of customers in my job, either through the Microsoft field or at conferences and many times we hear the same: “We love Power BI and we as IT have enabled it for everyone now”. Of course this is great news that we love to hear. Unfortunately that approach rarely works. Users in the organisation don’t know the tools exist, how to get access, where to find good data sources, already uses... Read more

Learn AAD when you manage a Power BI environment

I get many questions around Power BI and security related features. Users and customers often don’t realize that most of their requirements can actually be solved by AAD. Power BI uses AAD to handle authentication and authorization. Because of this we can also leverage all the features of AAD to add additional security and rules to Power BI. If you want to understand how AAD and Power BI work together guy in a cube has... Read more