Forum Discussion
cross filter for table
Hey all,
I hvae two datasets both containing id and year column plus some other information.
For both datasets one can choose an id and then compare the two.
My idea is to only show observations of the id of dataset 2 for the years in which there exist observations of the chosen id in dataset 1 in a table. How do I filter this table with id2 by the existing years of id1?
Kind regards
Susanne
2 Replies
Anonymous can you share sample data and what you are trying to do, also share relationship between these two tables?
Hi Anonymous ,
Drill through cross report should be a work around. Please check the online document as below.
https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through
