Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

multiple date tables to only use 1 date. How?

I have 6 data sets, all with graphs. I need them all to use 1 date, but each time i make the date table it doesnt work.    I have tried user relationship which retrns an incorrect syntax error mess...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

You can consider to change the filter direction to both, you can refer to the following link.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#cross-filter-direction

If the solution cannot meet your requirement, can you provide some sample data and the output you want, and please hide your private information.

 

Best Regards!

Yolo Zhu

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

     

    these are 2 data sets. Notices report and Late notices. I want to replace the issue date with a calendaer table date and count the local ref.

     

     

     

    I changed the directin to both and now blanks. I need the top left date to be calender date to run both visuals.

     

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous 

      Do you want to calculate the sum of the number of local refs that match the selected date in the two tables based on the date selected in the date table?

       

      Best Regards!

      Yolo Zhu

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous 

         

        I want to count them. I want to put both data sets on 1 line chart eventually using the 1 date from the calender, as well as individual graphs using 1 slicer.

         

        Thanks