March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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]
Solved! Go to 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.
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.
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.
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
|
Thanks for the reply!
What exactly did you change? Can you provide a bit more info or screen shots of what you did?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
128 | |
90 | |
75 | |
56 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |