Forum Discussion

GrahamR99's avatar
GrahamR99
Resolver I
6 years ago
Solved

Slicer for two data sets

Hello I have two querys query1 and query2 they both have Area, Shop Name and Shop Ref, I want one slicer to filter on both querys.  The two query have sumed fields but for different data.   I setu...
Need Help
  • VasTg's avatar
    VasTg
    6 years ago

    GrahamR99 

     

    Goto Options and Settings and disable this feature.

     

     

    If this helps, mark it as a solution

    Kudos are nice too.

     

     

GrahamR99's avatar
GrahamR99
Resolver I
6 years ago

Hello VasTg

Sorry I'm not allowed to give you my Power BI file.

 

I have started from scratch and found that Power BI is automatically creating relationships between tables that are similar but I don't want a relationships between.

 

Is there a switch in Power BI to stop this automatic relationship from happening?

 

Regards

 

GrahamR99

VasTg's avatar
VasTg
Memorable Member
6 years ago

GrahamR99 

 

Goto Options and Settings and disable this feature.

 

 

If this helps, mark it as a solution

Kudos are nice too.