Forum Discussion

IntaBruce's avatar
IntaBruce
Resolver I
2 years ago

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 m...
Need Help
parry2k's avatar
parry2k
Super User
2 years ago

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

IntaBruce's avatar
IntaBruce
Resolver I
2 years ago

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.