Hi Team,
I am playing around with the data from the publicly available StackOverflow2010 database (from the StackOverflow website) in Power BI, and i have created a data model like this.
The PostsSubset table is a subset of the Posts table, and the vwTagNameAndPostID is a view holding post IDs and the tag names retrieved from the Tag column in Posts table.
By default, the cross filter direction for the relationship is single, and PostsSubset is on the one side(dimension table), vwTagNameAndPostId is on the many side(fact table). Ideally this situation should be reversed as the vwTagNameAndPostId is holding more like categorical values while the PostsSubset is holding more like quantitative values such as '‘Score’, ‘SolutionMinutes’ etc…May i ask if there is a way that can switch the relationship between those two tables?
Kind regards,
Lu