Forum Discussion
AndrewPF
Helper V
3 years agovisual-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
- lbendlin
Super User
How are you filtering that field? Is that field controlling the data in your visuals via the data model?