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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
WheelchairWilly
Helper II
Helper II

Why does my slider only change one of the two?

What do I need to do to correct as to why the slider only changes the display on the right. Are the relationships at fault?
Screenshot 2023-08-06 135639.pngScreenshot 2023-08-06 140355.png

2 ACCEPTED SOLUTIONS

Happy to learn it is working now.

 

Do you mind marking the response as a solution so others can find it useful?

 

Yes, you can post the file.

View solution in original post

Hi,

 

This looks to be a new request, somewhat different from the original topic. You may want to mark the initial issue resolved (if indeed you can now control the two visuals with your slicer), then post this as a new topic.

View solution in original post

9 REPLIES 9
FataiSanni
Helper I
Helper I

If you check your date/Bav column, you will notice it doesn't have that calendar icon beside it, that is most likely because it is not in date format. 

You will need to format the Date/Bav column as date. This link may help.

Thanks for your reply FataiSanni.   I was able to get a relationship between Dates-Bav Team and Dates-Strikers.  So now both work together.  I was wondering if I could post of this file to you so you could correct a few things that I can't get get my head round? (The data is all made up by me for the new season starting this Friday)

Happy to learn it is working now.

 

Do you mind marking the response as a solution so others can find it useful?

 

Yes, you can post the file.

It didn't work the way I wanted it to. Here's the link to the folder with two files. 

https://we.tl/t-3cDOlb5WJs

What I want to show is, who in the Baverian Team picked the correct player(s) from the list in the Scorers Team. The compared column never seems to work for me! I have included a file,Strikers, you will see in the file called Pivot Data that this shows that the Bavarian Team got 18 scorers right. If you could highlight in colour the names that would be great. Feel free to get back to me if this sounds crazy. 

Hi,

 

This looks to be a new request, somewhat different from the original topic. You may want to mark the initial issue resolved (if indeed you can now control the two visuals with your slicer), then post this as a new topic.

parry2k
Super User
Super User

I think it is a relationship issue. Can you make sure the date column doesn't have time value. It is pure date value without time. Here is the link to the edit interaction https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k
Super User
Super User

@WheelchairWilly also make sure edit interactions between the visual is set to filter.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k
Super User
Super User

@WheelchairWilly the visual which is not getting filtered, which column you are using for dates, it has to be from the common dates table.

 

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

I've tried all three Dates, (Bav and Striker). Bav dates operates the Bav and Strikers operates the strikers. When I use Dates/Weeks both data is removed? Not sure what you mean by 

"edit interactions between the visual is set to filter."

 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 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.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors