In Power BI Visual Reports, you can use tooltips to provide additional data for specific data points in which the user is interested. By hovering with your mouse over the…
In an earlier blog, I described a solution for the use of Value Level Security (VLS) when users can be a member of multiple roles. (The general concept of VLS…
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…