How to fix Power BI slicers when it shows duplicate values due to the many-to-many relationship

[sumiteshkumar]

I've created 3 columns 'Value_BU', 'Value_PRACTICE', 'Value_SL' from unpivot in table 'SL_BU_PRACTICE'

'SL_BU_PRACTICE' joins with column 'c_number' to table 'projects' with column 'contract',

Using table 'SL_BU_PRACTICE' and table 'projects' i have created a visual.

I am encountering a common issue in Power BI where slicers show duplicate values due to the many-to-many relationship between the tables.

For reference i have attached a snapshot, also renemed 'Value_PRACTICE' to 'Practice' and on search i have used 'data' keyword to narrow search

How to fix it

[Anonymous]

Hi, @sumiteshkumar 

Have you solved your problem? You can try to merge the two tables in power query and do some data transformation to remove duplicate values.

Merge queries overview - Power Query | Microsoft Learn

Working with duplicate values - Power Query | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[audreygerred]

Hello! You should avoid many-to-many relationships, it can result in odd results. Instead, relate your fact tables to dimension tables. Your filters should be coming from your dimension table (which holds unique values). Understand star schema and the importance for Power BI - Power BI | Microsoft Learn

In this case, you would have a Practice dim table that would have each practive listed once (and whatever other attribute goes with it), and that would be joined to your two fact tables. Then, the filtering would come from the Practice dim.