Forum Discussion

Malina36's avatar
Malina36
Frequent Visitor
1 year ago
Solved

One slicer for two tables

Hello,   I have two tables in PBI; actual values and target values. The values should be shown in a bar chart. The relationship is based on date. I want to add a few slicers to that, they come from...
DAX
power bi
  • johnt75's avatar
    johnt75
    1 year ago

    Double check that you are creating the many-to-one in the right direction. It sounds silly, but it is easy to choose one-to-many rather than many-to-one, or vice versa, as it depends on which order the tables are listed in the relationship window. I know I've made that mistake before.

vivek31's avatar
vivek31
Icon for Resolver II rankResolver II
1 year ago

HI Malina36 ,

1) you can create a dimension table 
Dim_Slicer_Table = DISTINCT(UNION(VALUES(TargetValues[SlicerField]), VALUES(ActualValues[SlicerField])))
Replace SlicerField with the column name you want to filter by.

2) create relationships
    connect Dim_Slicer_Table  to actual values
    connect Dim_Slicer_Table  to actual values

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

 

 

Thank you



 

 



 

  • Malina36's avatar
    Malina36
    Frequent Visitor
    1 year ago

    Thank you. It doesnt work as it should. Probably bc of relationships. I can only habe m:n relationship. One to many is not possible.