🔥 3-day streak
Microsoft Power BI Data Analyst101 / 205
Question 101 of 205
Your model has a Sales fact table with a many-to-one relationship to a Product dimension. Business users report that a matrix showing Product Category rows correctly filters Sales measures, but when they place a Sales-based measure into a slicer context, the Product table does not get filtered by selections made on other visuals that use Sales attributes. The relationship is set to single cross-filter direction (Product filters Sales). Management wants Product visuals to also respond when users interact with certain Sales-derived selections, but they are concerned about introducing filter ambiguity elsewhere in the star schema. What is the most appropriate action?
Reviewed for accuracy · Report an issueNext question