How to make two slicers work independently on two visuals with one fact table?

[JustinDoh1]

I have uploaded my PBIX file here (JD_250909.PBIX).

I am trying to use two slicers for two visuals separately using one Fact table.

But, currently, when I use one slicer, both visuals are affected.

Previously, I had a PBIX file (JD_220620.PBIX) that was working as intended (two slicers affecting two visuals independently), but I am not sure why this particular one is working, but not the 1st one (JD_250909.PBIX).

I think only the difference might be "Calendar" & "DimDate" slicers are created with different code (measure vs. PowerQuery).

But, I don't know if that makes a huge difference of how data moves.

Thanks.

[JustinDoh1]

@Greg_Deckler  Thank you for your help.

But, actually, I have to use those separate slicers as "DimDate" performs differently when I publish it, and can't use for top visual (to meet the requirement). 

[Irwan]

hello @JustinDoh1 

like @Greg_Deckler said, you can edit visual interaction.

your interaction seems little bit off.

your interaction block only slicer, not the line or table visual. that makes when both line chart and table still affected.

try changing the interaction to only connect top slicer to line chart and bottom slicer to table.

Thank you.

[audreygerred]

Hi - for this you will want to do edit interactions. Select the top slicer, then turn edit interactions on and turn the interaction to the bottom chart and slicer off. Then do the same for the bottom slicer by stopping its interaction with the top slicer and chart.

I threw the below quick example together. The let slicer affects only the right chart and the right slicer affects only the right chart:

Here is what interactions look like for the left chart:

And for the right:

You will likely also want to turn off interaction between the charts themselves and the charts and slicers. For more detail on editing interactions, here is a link: Change how visuals interact in a report - Power BI | Microsoft Learn

[JustinDoh1]

@audreygerred Hi Audrey, Thank you for your help. I am having little difficulty finding the spot from my slicer to see that options. Are they available from my slicers? Thanks.

[audreygerred · Accepted solution]

Hi - yes, I attached the file in my last post with the interactions set. When you select your slicer, go to the ribbon and select Format, from there you can turn on Edit Interactions. The way you have your charts, the icons are kind of hiding on top of each other, but you should be able to see them. 

I moved your bottom visuals a little lower so it is easier to see the icons and am re-attaching. 

[JustinDoh1]

@audreygerred Thank you so much. It is clear now. I did not even know this type of functionality exists until now. lol. I will take a look more closely tomorrow and let you know if I have any question. 🙂

[audreygerred]

My pleasure - have a great night! Feel free to follow my blog. You've inspired me for an upcoming article - I will do this feature. www.powerbiwithme.com 

[audreygerred]

When I edited the interactions in the file you attached, it works as expected. Top chart is from April, bottom is March: 

[Greg_Deckler]

@JustinDoh1 Select one of the slicers. Under Format, choose Edit interactions. Disable interaction with one of the visuals. Rinse and repeat for the other slicer.