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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
IntaBruce
Helper II
Helper II

Slicer problem

Sorry for the unclear title of this problem, but I didn't know what to call it.  Here is my problem:

I am using a dropdown slicer to select a week that filters a table.  The table displays various measures such as the count and value of sales enquiries and sales proposals and the number of won and lost cases that pertain to that week.  See example here: 

IntaBruce_0-1702823502872.png

I want to show a second table that displays the same information for the previous week, and then a third for the week before that.

I can do this with 3 separate slicers that each influence their own table but that requires the report user to select 3 dates for the 3 slicers.  I want a single slicer to drive all three tables.  Is that possible?

Thank for your help

 

2 REPLIES 2
parry2k
Super User
Super User

@IntaBruce Yes this is possible, you need to create a disconnected table for the slicer, and then based on the selected date you can write measures to achieve the results for all 3 visuals.

 

I have a playlist on the various use cases of disconnected tables, check it out here Mastering Disconnected Tables in Power BI - YouTube



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.

Thank you @parry2k for your reply.  Wow that's a lot of videos, I've subscribed to your channel and will go back and take a long look through.
Meanwhile though I wonder if you could be a little more specific for me on my problem.  You say use a disconnected table, by this do you mean a second calendar table?  How then do I use it in a slicer to filter three separate table visuals with diferent date ranges?

Thanks for your help.

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.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.