Forum Discussion
Using a Slicer to Indirectly Filter a Line Chart
I have a scenario I need help with. BACKGROUND I have a table of data that contains the following columns. Project Person Date Hours Type FTE There are two slicers. These slicers are...
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'))
I assume you are talking about the Resouces page in your new file? In the bottom chart on that page you have explicitly added FTE_Check to the tooltip field well. If you remove that measure from the Tooltip I think this will fix your issue.
Oh, geez! What a rookie mistake. Thank you.