Cross filtering in Power BI – simple explanation
Did you know, what exactly means the “Cross filtering” option in relations setting in Power BI?
Let´s have two tables, connected by relation using the “Team” column as a key.
Let´s create two simple Table visuals (or any similar visuals…). The table on the “1” side of relation, team leaders, will always filter the table with names.
The difference is how the table with names (“ * “) side filters the Team leaders table. If the Cross filtering is “Both”, the filtering from Names to Teams works:
If the Cross filtering is “Single”, the filtering from Names to Teams doesn´t work: