There are tons of options in Power BI to add your custom logic. Varying from SQL expressions at data ingest all the way up to Visual Calculations to add logic on a visual level. But how do they compare to each other, where should you do what? As I've been a fan of making DAX …
Continue reading Comparing calculation options in Power BI, including Visual Calculations
You might have seen some buzz around already, although the official blog post is not out yet, the February release of Power BI desktop is already available to download. After a month waiting (traditionally, there is no January update) it has some great new features in it! Not only Tabular Model Definition Language is there …
In case you're working in an international company, you might have to deal with multiple languages and cultures at the same time. As not in all countries and businesses, it is common that everyone speaks and communicates in English all day, it can be relevant to support other languages for your Power BI solution. But …
Continue reading How to make your Power BI solution support multiple languages
Over the past few days, I attended the Power BI Next Step conference in Lego land - Denmark. During the keynote, Will Thompson - PM on the Power BI team, showed a new DAX function that is available to all of us already, but was very well hidden in the latest builds of Power BI …
Continue reading How OFFSET in DAX will make your life easier
Back in January 2020, I visited the Power BI Days in Belgium, where I had a talk about custom page navigation in Power BI. I already started playing around with the Power BI REST API and URLs to create a personalized navigation. As other bloggers might recognize, I ended-up as a draft blog but I …
Posting a blog on Sunday, yeah...why not. This time posted from the beautiful city of Stockholm. I traveled to Stockholm to attend SQL Saturday Stockholm #851 this weekend as a speaker. Today, Sunday, I'm still here to do some sight seeing. So I wrote this blog post with the below shown view. Could be worse... …
Power BI is the (best) data visualization tool of Microsoft. But how to apply your color formatting to your visuals without changing it by hand for every visual separately, which is an option of course, but in case you will get a next category in your visual, you have to manually add this to your …
Continue reading Format your colors based on Advanced Controls
Data - Marc 