topic Re: Line and stacked column chart does not filter everything that's need to be filtered in DAX Commands and Tips

Line and stacked column chart does not filter everything that's need to be filtered

Anonymous — Fri, 19 Aug 2022 11:16:48 GMT

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!

Re: Line and stacked column chart does not filter everything that's need to be filtered

lbendlin — Sat, 20 Aug 2022 17:24:26 GMT

(no relationships with any other table)

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

Re: Line and stacked column chart does not filter everything that's need to be filtered

Anonymous — Sun, 21 Aug 2022 08:16:10 GMT

One side gets filtered without relationships with a measure

Can't it be the case on the other?

Re: Line and stacked column chart does not filter everything that's need to be filtered

Anonymous — Sun, 21 Aug 2022 09:31:31 GMT

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

Re: Line and stacked column chart does not filter everything that's need to be filtered

lbendlin — Sun, 21 Aug 2022 11:19:36 GMT

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

Re: Line and stacked column chart does not filter everything that's need to be filtered

Anonymous — Sun, 21 Aug 2022 11:23:05 GMT

And how do we solve this problem with getting wet and washed?

Re: Line and stacked column chart does not filter everything that's need to be filtered

lbendlin — Sun, 21 Aug 2022 16:41:39 GMT

by creating a relationship between tables where filters in one table can impact the rows in the other table.