Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
(no relationships with any other table)
How do you expect it to get filtered without a relationship?
And the other thing is that it has no unique values to create a relationship in the first place:(
Where I come from we call this "wash me but don't make me wet"
And how do we solve this problem with getting wet and washed?
by creating a relationship between tables where filters in one table can impact the rows in the other table.
One side gets filtered without relationships with a measure
Can't it be the case on the other?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
42 | |
39 | |
33 | |
19 | |
18 |