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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
hoyt22
Helper I
Helper I

Values in slicers disappearing when using separate date slicers for matrices

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.

 

Screenshot 2024-10-05 192817.png

 

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]

1 ACCEPTED SOLUTION
v-yajiewan-msft
Community Support
Community Support

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:

vyajiewanmsft_0-1728441865699.png

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.

View solution in original post

5 REPLIES 5
v-yajiewan-msft
Community Support
Community Support

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:

vyajiewanmsft_0-1728441865699.png

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.

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
Super User
Super User

@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 

tharunkumarRTK_0-1728192990524.png

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!


PBI_SuperUser_Rank@2x.png

Thanks for the reply!

 

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

@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!


PBI_SuperUser_Rank@2x.png

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.