Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

relationships

Hello every one,

 

I have an problem in power bi .I have 8 tables and build a relationships .some of the relationships  are active some are  inactive.When a column drag into the slicer it shows the values only from the tables whice are participate in active relationship.But I want the values from the tables which are in inactive relationship.Please help me.

 

Thanks,

Chunduri

Data Modeling
Reports
  • Anonymous's avatar
    Anonymous
    8 years ago

     Hi Qiuyun Yu ,

     

    I used 'Userelationship function' and  it is working.

    Thank you.

     

    Regards,

    Chunduri

2 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi Anonymous,

     

    The slicer values are displaying based on active relationships rather than inactive relationships. 

     

    In Power BI, we can create a measure to use USERELATIONSHIP Function (DAX) to calculate values based on the inactive relationships. But we can't put a measure in the slicer visual, we can show the final result in another visual eg: table visual. 

     

    Best Regards,
    Qiuyun Yu 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

       Hi Qiuyun Yu ,

       

      I used 'Userelationship function' and  it is working.

      Thank you.

       

      Regards,

      Chunduri