Forum Discussion
Filter/slicer problems with calculated columns?
I'm trying to apply filters or slicers to my data in the report view without luck. Might have something to do with calculated columns?
I have one table that is a list of work for the year (2266 jobs total across all 'programs' and 'areas'):
I created a second table (with all calculated columns) to calculate how many jobs need to be done each day such that they're all complete by end of year. Then you can see how many jobs should be remaining on each calendar day. This is shown by the target 'Burndown' column:
In the report view, this target burndown line plots nicely (showing 2266 jobs on Jan 1 and 0 on Dec 31). However, I'm trying to add filters or a splicer so that I can see a burndown line only for jobs with a certain "program" or "area" attribute. As you can see, I've set up a filter to show only "south" areas and "instrument" programs - yet the burndown line remains unchanged.
Is there a reason the filters aren't applying to my calculated columns?
12 Replies
- nandukrishnavs
Community Champion
You have to enable the relationship between these two tables.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂 - amitchandak
Super User
401evolr , is this new table joined with your dimension table, so that filter can apply
- 401evolr
Helper II
Yes, here are the relationships I have set up:
- 401evolr
Helper II
Thanks for the replies nandukrishnavs and amitchandak
Changing the relationship to "bi-directional", I'm able to filter it somewhat, but it's incorrect. It changes the date along the x-axis, whereas I'm expecting it to change the number of jobs shown along the Y-axis: