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'))
Anonymous wrote:
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.
Oh hang on, are the values 0 or blank? Because blanks are always eliminated from visuals. If the values are actually blank not 0 one possible fix is to make a new measure:
[FTE (for chart)] = SUM( Table[FTE] ) + 0
If this does not solve your issue can you post an example pbix file or even just 5-10 rows of example data which exhibit this issue?
If you go to page 3 of 5 (the one named Projects) you will find my problem.
In order for the projects filer to show only the projects that have FTE hours in the date range selectred in the Date slicer on the Slicer page, I used a filter where FTE is greater than Zero.
In order to have the same list of projects in the line chart below the Projects slicer, I used the same FTE > 0 fitler. The probelm is, this gives me the right list of projects, but it also doesn plot any values where FTE = 0 for those projects. None of the projects have FTE > 0 on 2/7 and 2/14. This can be seen in the AVL/PLN line chart above the Projects line chart. PLN FTE hours on 2/7 and 2/14 are zero.