Help Needed: Slicer Not Showing All Data from Two Tables

[Amela]

Hello Power BI Community,

I've encountered an issue with a table visualization in Power BI, which combines data from two different sources. My goal was to implement a month slicer that dynamically updates the displayed data according to the selected month. After some research, I discovered a method to synchronize this slicer across both tables, expecting that selecting a specific month would adjust the data displayed for both sources accordingly.

In my visualization, which includes various names and their associated values, I noticed an unexpected behavior: upon selecting a month via the slicer, certain names disappear despite having relevant data for the chosen month. It appears the root cause is the slicer's limitation to only displaying names that have matches in both tables.

This presents a challenge, as I need the visualization to display all relevant data, regardless of whether the names match across both tables. Could anyone advise on how to configure the slicer (or suggest an alternative approach) to ensure all pertinent data is shown, even if the names do not have a direct match in both tables?

Thank you in advance for your support and guidance.

[PijushRoy]

Hi @Amela 

Please create calender table or DimMonth table and create relationship with both fact table.
Please check spelling and if there are any extra space in both table month name, if yes, please correct.

In slicer, please use month from DimMonth table. It will filter both table

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[Amela]

I had already set up a dedicated date dimension table (DimDate) to facilitate filtering across the two fact tables. However, I'm facing a challenge with the relationships between this dimension table and the fact tables. Power BI allows only one of these relationships to be active at a time, making the other relationship inactive (shown as a broken line).

Attempting to activate both relationships results in an error due to "ambiguous paths between the tables." Consequently, depending on which relationship is active, only the values from the related fact table are updated when I select a month; the values in the other table remain unchanged. This limitation led me to explore synchronized slicers as an alternative solution, given the difficulties in leveraging the DimDate table effectively.

Is there a workaround or best practice that would allow both fact tables to dynamically update through the slicer, despite the direct relationships being limited by Power BI's "ambiguous paths" constraint?

Thank you once again for your help and patience.