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
MP-iCONN
Resolver I
Resolver I

Table visual not filtering Date Slicer

We have a report that has a table visual of bookings by week.  What I need to do is be able to click on one of those weeks in the table visual and see if it can change the date range in the date slicer.

 

As you can see I have Week 17 selected in the table visual but it does not change the Date Slicer.  I also made sure that under Edit Interactions the table was set to filter the slicer.  The table visual and Date Slicer are all in the same table as well.

 

MPiCONN_0-1652359253975.png

 

Not sure if this is expected behavior and a limitation in Power BI or if I am doing something wrong.

 

Any advice or help is greatly appreciated.

 

 

3 REPLIES 3
v-cgao-msft
Community Support
Community Support

Hi @MP-iCONN ,

 

Did my answer help you? If any post is helpful, please consider accepting it as a solution to help other members find it faster. thank you very much!

 

Best Regards,
Gao

Community Support Team

v-cgao-msft
Community Support
Community Support

Hi @MP-iCONN ,

 

Although the documentation doesn't say which visuals support cross-filtering and cross-highlighting. But through daily use and experience, the slicer does not have such an interactive function.

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

HotChilli
Super User
Super User

It's not really expected (or desired) in IT in general.  The date slicer is the dimension you want to slice and dice the facts in the table.  It's not really workable for the table to filter the slicer which filters the table etc.

Hope that helps.

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.