Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Filtering visuals using slicers combinations

I have a table called "CoppeCitte" with several columns, you can see below a sample:

 

Bimbone_0-1745913840149.png

 

 

 

Then, I have all the visuals in the below page:

 

Bimbone_1-1745913840153.png

 

 

You can see the three slicers: "Competizione" on the left (filtering the same column "Competizione"), "Scegli anno" in the middle (filtering the year in the column "Anno") and the cities on the right. This last slicer is actually filtering another linked table, but it gives the same value as the column "CittaMain".

If you look at the table in the centre bottom, what I want to achieve is that instead of showing all the records, it gets filtered on the "SFPair" which corresponds to the combination of the three slicers above.

 

I have been trying several methods using measures, but I cannot get the result I want.

 

Any further feedback or suggestion would be appreciated. Thanks!

Status: New