Forum Discussion
Line and stacked column chart does not filter everything that's need to be filtered
So, we have the separate table "At risk parts"(no relationships with any other table) which the visual should be based on this:
And a chart that was requested should look like this (3 distinct count of projects on left axis, 3 at risk parts on right axis):
"At risk parts" here is a measure based on other table(s).
The problem:
- Whenever I filter the dashboard the visual should get filtered, too. It gets, but partly. "Line values" part gets filtered fine (whenever I slice, values change as they supposed to), but the "Column Series" and "Column Values" parts of the visual stay the same. How do I get them filtered, too? Is there any DAX measure to help with? I watched a couple of videos on YouTube but didn't get it
thank you!
6 Replies
- lbendlin
Super User
(no relationships with any other table)How do you expect it to get filtered without a relationship?
- AnonymousNot applicable
One side gets filtered without relationships with a measure
Can't it be the case on the other? - AnonymousNot applicable
And the other thing is that it has no unique values to create a relationship in the first place:(
- lbendlin
Super User
Where I come from we call this "wash me but don't make me wet"