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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
hoyt22
Frequent Visitor

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.