Forum Discussion
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
Ok, perhaps if I were able to add a date column it would solve this problem. However my calculated table is a summary built from measures and sums of columns so I have lost the individual rows (and hence their date entry). That makes it impossible to add a date column to this table. So to solve it I think I am going to have to build my calculated column back in the original table. I've been trying to do that however the calculated column needs to take into account other measures and columns from other tables and I'm getting quite unexpected (to me anyway) results.