Dynamic buttons in Power BI (2)
In my previous blog post, I have shown you one method to create dynamic buttons in a Power BI visual report, resulting in a dynamic drill through page. In this…
In my previous blog post, I have shown you one method to create dynamic buttons in a Power BI visual report, resulting in a dynamic drill through page. In this…
For a few years now, we have worked with the concept of Value-level security (VLS). In short, VLS allows you to secure the visibility of not rows, as with Row-level…
If you are not in the US, chances are that your organization works with a calendar based on the ISO 8601 week numbering system. In the ISO standard, weeks…
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…
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…
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,…
In this third blog about achieving a different mindset when you want to change your business tools from Excel to Power BI. In the first blog I wrote about the…
In this second blog about achieving a different mindset when you want to change business tools, I want to talk about the creating an extra numeric column as relation column…
This blog is all about achieving a different mindset when you want to change business tools. If you used to work with Excel and want to take the path of…
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,…