Timeline Slicer with Calculated Tables

Calculated tables and calculate columns do not respond to slicers. If your slicer is related 1 to many to the calc table or table with a calc column the slicer will filter the table in the many side.  Does that answer your question?

Hi KarlinOz

Does the field you use in your timeline slicer come from a Date/Calendar table?  And have you made a relationship between your calculated table and your Date/Calendar table?

Just a thought.

So for completeness I'll post what I did to get it to work.

I had to move my measure back to one of the source tables and to get the measure to work correctly I had to create two new columns in my source table - I gather I could have just written the code for the two columns into the measure but after a couple of hours of trying I gave up and created the new columns. 

This is probably a good object lesson in why creating new tables is not always the best solution.

Hi KarlinOz,

Great to hear the problem got resolved! Could you accept the helpful reply as solution to help others who may have similar issue easily find the answer and close this thread?:smileyhappy:

Regards