Driving 2 Charts with a Data Slicer

[Walt1010]

I have 2 table charts, depicting incoming and outgoing callls by date. The actual data for these 2 is stored in 2 separate tables. I've created a data table and linked the date values in the 2 tables to the date in the date table. It looks ok, the relationshsips are many to one and the connections are active.

I'd like to focus on individual months, and so I created a slider, using the date value in the date table as the value.

But when I click on an individual month the table charts show blank.

Any ideas? 

[Alican_C · Accepted solution]

It sounds like the issue might be related to how the relationships between your tables and the date table are set up, or how the filter context is being applied. Here are a few steps to troubleshoot and resolve the issue:

1. Verify Relationships:

   • Ensure that the relationships between your date table and the incoming/outgoing calls tables are correctly set up.
   • Both relationships should be "Many to One" (Many in the calls tables to One in the date table).
   • Make sure the relationships are active.

2. Check the Date Format:

   • Ensure that the date format in the date table matches the date format in the calls tables.
   • Sometimes discrepancies in date formats can cause filters not to work as expected.

3. Use Correct Date Column in Slider:

   • Verify that the date column you are using in the slider is from the date table.
   • Ensure that the date slicer is set to filter by the correct date column.

[Walt1010]

Thanks! Your structured answer made me work methodically through the options. My problem was a different format in one of the tables that I'd known about but kinda dismissed as not being an issue:)