Filter a visual based on a slicer value for a different field with the same type of data

[glenyj]

Hello,

Im trying to filter a visual by the value from a slicer.  I'm trying to filter a different field that has the same categories of values.  For example, The slicer is based on "Shape".  Based on the selected value from shape, I want to filter the values in "Shape2" to those shapes only and display a count of the values of "Shape3".  For example, I have filtered the table assuming the user selected square.  Then I would want my visual to show pentagon with a count of 4, heart with a count of 6, circle with a count of 2, and triangle with a count of 2.  I was trying to use a waterfall chart for the shapes and counts.  I tried using an approach I saw in another post (https://community.fabric.microsoft.com/t5/Desktop/How-do-I-get-the-value-from-selected-slicer-and-th... seemed like a similar problem, suggested creating a measure and then using it as a filter on the visual, but that didn't work.  I turned off the filter interaction between the slicer and this particular visual because I want it filtered on a different field than the one the slicer is linked to.

link to pbix file - https://1drv.ms/u/s!AugzWMQZ_6iugTJwn601ASjfVTyH?e=vJo6um
link to testdata - https://1drv.ms/u/s!AugzWMQZ_6iugTO1yGpkZdSC3D_k?e=e62fdG

example of what I would like below

[mickey64 · Accepted solution]

I use your PBIX-File.

How about these results?

- Slicer -

- Matrix -

[Anonymous · Accepted solution]

Hi @glenyj ,

Canceling an interaction doesn't mean it won't be filtered. So you may need to filter for each of the three visual objects. You can check the results below:

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[Ashish_Mathur]

Hi,

I cannot download the file.  The screen just keeps flickering.

[glenyj]

Hello @Ashish_Mathur, can you try again now?  I just tried it and it works.  What browser are you using?  I tried it with both Edge and Chrome and it worked.

[Ashish_Mathur]

I am using Edge.  It is still not working.

[mickey64]

Step 0: I use your data below.

Step 1: I duplicate 3 columns.

- Before -

- After -

Step 2: I unpivot these 3 columns and click 'Close & Apply'.

Step 3: I make a slicer and a table.

- Slicer -

- Table -

Step 4: I make 2 measures and add 2 Cards for these measures.

    M_Cost1_Sumx = SUMX(

        SUMMARIZE('DATA','DATA'[Shape],'DATA'[Shape2],'DATA'[Shape3],'DATA'[Cost1],'DATA'[Cost2],DATA[Day]),

        (DATA[Cost1]))

    M_Cost2_Sumx = SUMX(

        SUMMARIZE('DATA','DATA'[Shape],'DATA'[Shape2],'DATA'[Shape3],'DATA'[Cost1],'DATA'[Cost2],DATA[Day]),

        (DATA[Cost2]))

[glenyj]

Hello @mickey64 , thank you for trying to help!  This isn't what I'm trying to do.  I did update my description, which I hope provides more clarity

[mickey64 · Accepted solution]

I use your PBIX-File.

How about these results?

- Slicer -

- Matrix -

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[glenyj]

Hello @Ashish_Mathur , I have added links to the pbix and data files.