Forum Discussion
Filter different visuals on same selected value but from different dimensions
Hi KeithDunn ,
Could you please tell me the relationships between four dimensions or provide us some sample data?
And you can reference the following ducument which is about using one dimension to filter another dimension.
One Dimension Filters Another Dimension in Power BI - RADACAD
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- KeithDunn3 years agoFrequent Visitor
Thank you v-xiaosun-msft for your response. Here is a visual of the star schema described above. It includes only the elements needed to illustrate the question.
This is a typical data warehouse layout where there is a one to many relationship from each dimension table to the fact table. As a reminder, in our actual application this data warehouse has been used to build a tabular AS database, which is the data source for the Power BI report. In the real database there are other dimensions, including a Date dimension that could also separately filter the data. They are omitted here for simplicity.
Here is a limited set of sample data for the schema above:
From our knowledge of the source applications, we know that the list of region is a coded value and has a small number of valid values: North, South, East and West.
The use case is that the end user must be able to make a region selection from a single list and see three Table visualizations, one showing total RevenueAmt by Customer for the matching Customer Region, one showing total RevenueAmt by Reseller for the matching Reseller Region and one showing total RevenueAmt by Manager for the matching Manager Region.
For example, selecting South will give a Customer table showing Customer Two and a total revenue of $500, a Reseller table showing Reseller One with revenue of $500 and Reseller Three with revenue of $250 for a total of $750 and a Manager table with Manager Three and a total revenue of $500.
The real database has more fields and uses industry-specific terminology but this is an almost exact representation of the actual use case.
Using slicers, selecting "South" would require three selections since there must a separate slicer for each of the dimensions. This would be fine if the use case demanded this flexibility (and other use cases might). But this use case requires exactly one visible slicer to filter different dimensions in different visuals.