The importance of custom totals
In the march 2026 update of Power BI, Microsoft gave us a new feature that has been a bit underexposed. It does however make a very big change in development and performance. I am talking about the new feature ‘Custom Totals’… With Custom Totals a developer can now use visual calculations to adjust the totals […]
ISFILTERED
You probably know that the ISFILTERED function returns TRUE when the specified table or column is being filtered directly. But did you know that if you add multiple ISFILTEREDs together, ISFILTERED will not return true or false, but will return a number. You can combine this returned number with a switch function to influence your total levels.
Un-Bold Row Headers
Have you ever created a matrix visual, with hierarchy, where your row headers are formatted 𝐛𝐨𝐥𝐝? You can not seem to turn if off, because turning off the 𝐛𝐨𝐥𝐝 formatting in both the section 𝐯𝐚𝐥𝐮𝐞𝐬 and 𝐫𝐨𝐰 𝐡𝐞𝐚𝐝𝐞𝐫𝐬 does not seem to work? This is because the option to turn of 𝐛𝐨𝐥𝐝 formatting for row […]
Alignment of visuals
Have you ever heard of the “Align” button? It helps you to align visuals, no more precision drag-and-drop…
It also helps to distribute visuals horizontally of vertically over a canvas. This will give an overall alignment of visuals which would make your report so much cleaner.
Why you want to avoid a many-to-many relationship?
The Power BI data model is one of the most important aspects of a good Power BI environment. The data model is the way Power BI can navigate to achieve a good result. Creating a good and efficient data model will bring benefits in terms of performance, DAX encoding, and bug fixing. A right or […]
Value filter behavior
To quote the explanation of Microsoft: When you are filtering multiple columns on the same table, the current default value filter behavior takes these filters and combines them into one, considering only the combinations that exist…
Folder structure for measures
if you use a semicolon (;) between folder structures, you can show that measure in multiple folders…
Calculation Groups
I wrote a calculation group C# script so that you don’t have to …
The set up of Power BI service
In the Power BI service, one can publish reports, so that it is available to end users. Here one can also add security, so that end users only see specific data. Power BI service is the end station of a Power BI development and its purpose is to present and use the dashboard. Different forms […]
A datamodel based on practice
In order to arrive at a good and efficient data model, it is important to understand the proces of normalization in combination with different options of relationships …