Forum Discussion

AndrewPF's avatar
AndrewPF
Icon for Helper V rankHelper V
3 years ago

visual-level filter not working all the time

I am using the "Lipstick bar chart by Nova Silva" to show some actuals to targets. 

 

I have a visual-level filter as follows: 
 

 

where the relevant measure is: 

 

Chart filter = if(isfiltered(Assessments_combined[name]), 1, 0)
 

and it also has a dynamic title: 

 
Title ASTT = if(isfiltered(Assessments_combined[name]), "Average score to target - " & SELECTEDVALUE(Assessments_combined[name]), "AVERAGE SCORE TO TARGET - THIS CHART IS POPULATED ONLY WHEN ASSESSMENT NAME IS SELECTED")
 
all of which gives me this when no "name" is selected: 
 

 

However, this "Chart filter" doesn't seem to work with everything. 
 
It works in a lipstick chart, a table or a matrix but, when I try to apply it to a gauge or a line & stacked column chart, it doesn't work. 
 
Any ideas? 

1 Reply

  • How are you filtering that field?  Is that field controlling the data in your visuals via the data model?