Forum Discussion
Using a Slicer to Indirectly Filter a Line Chart
Ok, so the issue here is because your data model is different to what you described in your first post. In there you only mentioned a single table, so I shared code that would work with a single table, but because you have a separate calendar table and columns from that are on the axis of your graph you should create a measure like the following and use that to filter your slicer and graph
FTE (all time) = CALCULATE( SUM( 'Master Filtered'[FTE] ) , ALL('Calendar'))
That worked on the slicer. It gives me the same behaivor as if I just use a filter on the project slicer to be when FTE is greater than zero. However, it still doesn't fix the line chart it still doens't lot any zero values.
I need the following behavior from the line chart.
1) For a project where all the FTE in a date range add up to be zero, don't plot any values. I don't even want the project to show up as a series on the chart. It shouldn'ty be listed in the legend. I want it to be as if those projects don't even exit.
2) For a project where all the FTE in a date range add up to be greater than zero I want them to be plotted. But I also need the days where the FTE is zero to be plotted as zero. Right now, becasue the filter excludes anything that isn't greater than zero, it just treates those days that should be zero as missing data. It just connectes the FTE from the day before to the day after.
Another way of saying this is:
1) I want to exclude any series (project) where the sum of all FTE is 0
2) I want to include all other series (projects) and plot all FTE for those projects, even the ones equalt to zero