power bi Archives - Quanto blog site

Dynamic buttons in Power BI (1)

Post author:Madzy Stikkelorum
Post published:March 13, 2023
Post category:Power BI
Post comments:0 Comments

There are many ways to create a dynamic report in Power BI. A lot of the visuals that are available in Power BI also have a conditional formatting possibility to…

Linear regression in Power BI: the LINEST/LINESTX functions

Post author:Michiel Rozema
Post published:March 2, 2023
Post category:Power BI
Post comments:0 Comments

When analyzing large amounts of data, we are often interested in trends and correlations. One of the most basic methods to research these, is linear regression. Linear regression is a…

ALLSELECTED() and Report Page Tooltips

Post author:Michiel Rozema
Post published:February 16, 2023
Post category:Power BI
Post comments:0 Comments

The DAX function ALLSELECTED is a powerful function that accomplishes something that cannot be done otherwise. The simple version of what ALLSELECTED does, is this: like other ALL functions,…

AutoExist and the Case of the Missing Workdays

Post author:Michiel Rozema
Post published:November 23, 2020
Post category:Power BI
Post comments:0 Comments

This article is a follow-up to the AutoExists introductory post and one with an example on time intelligence based on workdays. In the latter, we created the month-to-date chart below,…

Data awareness or data ignorance?

Post author:Henk Vlootman
Post published:November 18, 2020
Post category:Excel Power BI
Post comments:0 Comments

I recently delivered a training about data awareness. Strangely enough data awareness is not a common practice within organizations. To my great surprise the impact of data on their business…

Let’s enjoy the weekend – workday analysis with DAX

Post author:Michiel Rozema
Post published:November 16, 2020
Post category:DAX Power BI
Post comments:1 Comment

In this post, I show an approach to non-standard time intelligence analysis. This is, in fact, the second article on AutoExist. In the first, I explained the general principle of…

Project month in Power Query

Post author:Henk Vlootman
Post published:November 10, 2020
Post category:Data transformation Power BI
Post comments:0 Comments

Working with dates in Power Query. How to set up a monthly series.

What is being calculated anyway? Understanding AutoExist

Post author:Michiel Rozema
Post published:November 9, 2020
Post category:Power BI
Post comments:1 Comment

When working with DAX measures, it is critical to think in terms of context. Those of you who have taken our course of DAX Fundamentals, or attended one of our…

Introduction to Drill Through in Power BI Reports

Post author:Michiel Rozema
Post published:November 2, 2020
Post category:Power BI
Post comments:0 Comments

One of the foundational features of Power BI visual reports is interactivity. The capability to interact with the report allows for primarily visual representation of insights, while at the same…