Multiple slicers for one visual

[nrustamli]

Hello there. I am trying to apply two separate sliders for one visual. The data I am working on has the following structure:

Countries	Year	Variable 1	Variable 2	Variable 3
Austria	2018	75	56	21
Austria	2019	7	52	43
Austria	2020	48	79	3
Austria	2021	73	69	17
Belgium	2018	82	57	56
Belgium	2019	67	36	11
Belgium	2020	3	44	55
Belgium	2021	1	90	52
Denmark	2018	22	34	56
Denmark	2019	85	15	48
Denmark	2020	5	31	57
Denmark	2021	57	27	100
Ireland	2018	72	18	37
Ireland	2019	78	19	54
Ireland	2020	15	97	62
Ireland	2021	37	45	72
Netherlands	2018	49	16	80
Netherlands	2019	99	94	65
Netherlands	2020	37	43	12
Netherlands	2021	84	85	13
Sweden	2018	30	79	9
Sweden	2019	54	89	4
Sweden	2020	55	76	64
Sweden	2021	99	93	94

The main purpose of the dashboard I want to create is to compare two countries/entities. I want to have the following structure:

So the idea is that, Slicer 1 picks the country for Figure 1, Slicer 2 picks the country for Figure 2, but both slicers should pick a country (each) for Figure 0 - so it should have two lines. When I pick one country in each slicer, the Figure 0 turns blank. Would appreciate any help to fix this, but also any ideas that would have a more straightforward way to represent this concept.

[Anonymous · Accepted solution]

Hi @nrustamli ,

The file is here, you can check if it is what you want.

Because I don’t know your needs, so the value shown in my picture is Variable 1.

Measure = 
CALCULATE (
    SUM ( 'Table'[Variable 1] ),
    FILTER ( 'Table', [Countries] = SELECTEDVALUE ( Slicer1[Countries] ) )
)

Measure 2=
CALCULATE (
    SUM ( 'Table'[Variable 1] ),
    FILTER ( 'Table', [Countries] = SELECTEDVALUE ( Slicer2[Countries] ) )
)

Measure 3 = IF(ISFILTERED(Slicer2[Countries]),[Measure])

Measure 4 = IF(ISFILTERED(Slicer1[Countries]),[Measure 2])

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hereskieu]

Hi Stephen, 

I have the similar project like nrustamli that I want to apply two slicers(filters) for one visual.  I tried to follow your measures but it ran into an issues.  It keeps telling me that 'Cannot find table 'Slicer1'.  Can you help me on how to fix it? 

TIA,

Kieu  

[nrustamli]

Thanks a lot Stephen, this indeed solves it!

[nvprasad]

Hi,

You can use the edit interactions option under the format tab (Select slicer first then go to format tab) to fix this issue.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

[nrustamli]

Hello, could you please elaborate on this? Because my first thought was about the interactions as well, here how the interactions of Slicer 1 look:

And here are the interactions of Slicer 2:

Anything else that needs to be done here?

[amitchandak]

@nrustamli , you need two lines one from slicer 1 and one from slicer 2. In that case you need independent tables(at least one)

refer my date example - You need to slicer for country in place of date

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[amitchandak]

@nrustamli , You should be able to do that with edit interaction. Switch interactions between 1 and 2.

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions