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.

This means, in a nutshell, that Power BI, by default, will give you the wrong results if you filter multiple categories on the same table, in the situation that not every combination exists.

To give some guidance to this new but very important feature, I made an attempt to visualize the difference between ‘Value Filter Behavior – Automatic’, ‘Value Filter Behavior – Independent’ and what would happen if you don’t filter on the same table, but instead create a star-model by dividing the table into dimensions and fact.

Sharing is caring!

Have a look at my other blogs

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

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.