Forum Discussion

tslupphaug's avatar
tslupphaug
Regular Visitor
3 years ago
Solved

Filter multiple fields/visualisations using one slicer

Hi.    I want to make a really simple report showing how many items have been created in each of three different SharePoint Lists on any given day using a date slicer. The lists/tables contains unr...
Need Help
  • Mikelytics's avatar
    Mikelytics
    3 years ago

    Hi tslupphaug 

     

    Please create a Date Dimension Table and link it with a 1:n relationship to the three tables. WHen you then put the date field of the Date Dimension Table into the slicers then all tables will be filtered.

     

    Best regards
    Michael
    -----------------------------------------------------
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Appreciate your thumbs up!
    @ me in replies or I'll lose your thread.

mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
3 years ago

Hi tslupphaug ,

 

you need to create a calendar table and then create 1 to many relationships between the calendar table and the facts tables, using the column Calendar[Date] as filter in your report.