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'))
My follow up question below is probably related to your explanation above. When I hover over a line in the line chart to get detailed data, I know get a mess of data. I used to get the project name and FTE associated with the project. Now I get three entries for each line.
Project [Project Name Value]
[Project Name Value] 0.00
FTE_Check [FTE Value]
Where the text above in the square brackets is reaplaced with the real data. Note: 0.00 never changes. It always says 0.00
Any thoughts on why this is happening and how to get back to what I had before?
[Project Name Value] [FTE Value]