Hi! I need to create a tab with a chart with number of employees over time and other vizualizations so they all that could cross-filter each other. I managed to do the chart, the DAX is:With 2 inactive relationships between 2 tables: (Date ->Start Date and Date -> End Date)And I can't figure out how to make this chart filter other vizualiations based on Append_Staff_data.I get why it doesn't filter, I can't figure out how to create dependencies so the vizes could filter each other.Any advice?Maria

I have found a mistake I made - I used ALL that removed all the filters.

Forum Discussion

Helper II

5 years ago

Solved

Hi!

I need to create a tab with a chart with number of employees over time and other vizualizations so they all that could cross-filter each other.

I managed to do the chart, the DAX is:

With 2 inactive relationships between 2 tables: (Date ->Start Date and Date -> End Date)

And I can't figure out how to make this chart filter other vizualiations based on Append_Staff_data.

I get why it doesn't filter, I can't figure out how to create dependencies so the vizes could filter each other.

Any advice?

Maria

Maria9292
5 years ago
I have found a mistake I made - I used ALL that removed all the filters.

AlB
Community Champion
5 years ago
Maria9292

can you share the pbix?

Please accept the solution when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.
- Maria9292
  Helper II
  5 years ago
  AlB sure, here it is. Thanks!
Maria9292
Helper II
5 years ago
Basically, I need to be able to see details of each date I choose: how namy employees are there, what departments they are from, their names etc.
If this can be achieved using different logic, I am open to any suggestions)
Maria9292
Helper II
5 years ago
I have found a mistake I made - I used ALL that removed all the filters.