Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

  • (no relationships with any other table)

    How do you expect it to get filtered without a relationship?

    • Anonymous's avatar
      Anonymous
      Not applicable

      One side gets filtered without relationships with a measure

      Can't it be the case on the other?

    • Anonymous's avatar
      Anonymous
      Not applicable

      And the other thing is that it has no unique values to create a relationship in the first place:(

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User

        Where I come from we call this "wash me but don't make me wet"