Forum Discussion

Spencer's avatar
Spencer
Helper II
9 years ago

Configuring relationships to enable slice

Hi   I've been struggling in my attempts to get information from both my Payroll and Payroll Transactions tables to slice by using slicers from the PayCodesTable and DeptTable. More specifically I'...
Need Help
BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

Hi Spencer,

 

You can double click on any relationships arrows and configure the relationships as per your needs. 

More information on types of relationships can be found in here.

Alternatively, This Blog by SQLBI will give you indepth knowledge of relationships in PBI and DAX.

 

 

Thanks & Regards,

Bhavesh

Spencer's avatar
Spencer
Helper II
9 years ago

Hi BhaveshPatel

 

Thanks for the links to those resources.

I'm still struggling however to get both my Payroll and Payroll transaction tables to slice by the DeptCode.

I've tried many different relationship structures and cross filter directions but still can't get it to slice correctly.

 

Thanks

 

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    9 years ago

    Hi Spencer,

     

    Happy to look further deep into the issue. Please post the sample file and your requirements.

     

    Thanks & Regards,

    Bhavesh