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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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