Values in slicers disappearing when using separate date slicers for matrices

[hoyt22]

Hi all,

I have a dashboard containing matrices with various rankings for advertisers within several markets.

On the third tab (TV Rank Comparison), I have created two matrices that are controlled by a different date slicer. Then I have an Advertiser and Market slicer that affect both matrices. The goal is to compare rankings during different time periods. However, when I start selecting dates, the values in my Advertiser and Market slicers start disappearing. I have to re-select dates to have things re-populate, and even then, values are missing.

Is there something I'm missing with the set up? Or is having two date slicers messing up the filtering, even though they should only be affecting one matrix? I appreciate any help with this.

Below is the link to my dashboard and a .csv file that contains all the markets and advertisers.

[removed]

[v-yajiewan-msft · Accepted solution]

Hi @hoyt22 ,tharunkumarRTK, thank you for your prompt reply!

As tharunkumarRTK said, If you want the selected visualization to have no impact on one of the other visualizations on the page, select the no impact icon:

More information for your reference:
Change how visuals interact in a report - Power BI | Microsoft Learn

Best regards,

Joyce

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

[hoyt22]

Thanks, Joyce! I eventually figured it out, but your screenshot is helpful.

For anyone wondering about the specifics, both of my date slicers were set up to impact my Advertiser and Market slicers, causing the values to disappear. As Joyce's screenshot shows, changing the interaction to None fixed the issue.

[tharunkumarRTK]

@hoyt22 

Based of my understanding of your requirements, you need to adjust the visual interaction of date slicers with Market  and advertisers slicer. As you can see, I did the same and I could see all markets and advertisers 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[hoyt22]

Thanks for the reply!

What exactly did you change? Can you provide a bit more info or screen shots of what you did?

[tharunkumarRTK]

@hoyt22 

You can find the PBIX file attached. And observe the slicer interactions 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!