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
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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
104 | |
103 | |
87 | |
61 |
User | Count |
---|---|
162 | |
132 | |
131 | |
95 | |
86 |