Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • d_gosbell's avatar
    d_gosbell
    5 years ago

    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'))
d_gosbell's avatar
d_gosbell
Super User
5 years ago

You may have to upload another example file, I'm not really sure what you are seeing or why. When I applied the fix to your example file I don't think it changed the tooltips at all.

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

d_gosbell 

 

Here is a link to the new file.

And here is a link to an image of what I am seeing.

 

Sorry for the late replay. I have been on holiday.

  • d_gosbell's avatar
    d_gosbell
    Super User
    5 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Oh, geez! What a rookie mistake. Thank you.