Forum Discussion

metcala's avatar
metcala
Icon for Helper III rankHelper III
3 years ago

Syncing Reporting Date Slicer

Hi everyone

 

I have the following tables - installation, maintenance inspection and decommissioning showing open jobs which are refreshed monthly. There are instances in which a job ID appears multiple times as it spans multiple months.

 

There are individual reporting pages each with a slicer linked to the Reporting Date column. This filters the date correctly but I am looking to have a slicer than syncs all reporting pages to the month selected.

 

I have created a date table and added EOMONTH() column however when I add relationship from the Reporting Date columns to Date[Date] it is only allows one active relationship and the other tables are linked by inactive relationships.

 

The visuals just show a summarised version of the table excluding columns and don't use any measures so not sure if USERELATIONSHIP() is possible.

 

Not sure if this is possible or how I would do it.

 

Here is an example of one of the tables and the report:

 

Installation Table

 

Reporting DateIDInstallation TeamInstallation LeadStart DatePre-Check Assessment Date...
.....................

 

 

Installation Report

Filter: Reporting Date

 

IDTeamStartExpected End
............

 

Any guidance would be much appreciated!

 

Need Help

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi, metcala 

     

    Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.