Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
U156531
Helper III
Helper III

Slicer only works on 1 of three visuals

I have a City Name slicer which I need to filter three different visuals. Only one visual (which has a Managed Relationship connection between the data in the slicer and the data in the visual is working.  I can't make managed relationship for the other two visuals even though they are based of of tables with city names. Is there another method? The city name is not in the visuals.  

 

Thanks

7 REPLIES 7
Alex87
Solution Specialist
Solution Specialist

Here is the pattern of activating inactive relationships using DAX -

CALCULATE(SUM([SalesAmount]), USERELATIONSHIP(FactInternetSales[CustomerKey], DimCustomer[CustomerKey]))

From what I see your relationship is many to many,bidirectional. This is not best practice. I recommend reading more about modelling and star schema. 

Disregard my last message, I was using the wrong table in the dax formula.

 

I tried the DAX that you suggested but I'm getting the following error. I include the manage relationship join.

 

U156531_0-1715721884898.png

U156531_1-1715721979155.png

 

Alex87
Solution Specialist
Solution Specialist

you can have in the model only 1 active relationship, but multiple inactive ones. Those inactive relationships can be activated using DAX. If you can provide a sample with dummy date I can help you

Here is the inactive relationship that I would like to active with DAX.

U156531_0-1715199550727.png

 

Alex87
Solution Specialist
Solution Specialist

If the dimension table used by the column in the slicer has a relationship with the table that contain columns in the other visuals, the filter will work. If it does not work now it means your model was not set correctly or the interaction was removed or you do not have any column to build a relationship upon

The problem is that I can't build a relationship between the tables for the city names. The model won't allow me to do that because there is already a relationship on another column needed for a different join. Is there a method to join outside of the managed relationsships? I've tried the Format/Edit Interactions but that does not produce the correct results.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.