Forum Discussion

NP2020's avatar
NP2020
Frequent Visitor
5 years ago
Solved

Comparing two tables with time data - forecast versus actuals

Hello - I am looking for some assistance with visualising some timesheet data. I am trying to visualise the hours planned for activities on our project against what was actually booked. I have crea...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    In the Dates Table there are blanks appearing in the Date column.  Remove those blanks rows.

NP2020's avatar
NP2020
Frequent Visitor
5 years ago

Thanks Ashish_Mathur , I have been able to download and review the PBI. I can see what you have done, but am unable to replicate the same relationships in my own PBI file.

Is there a specific method for creating this type of relationship?

Also, when I select Many to One, the Cross Filter Direction drop down has two versions for Single - Dates filters forecast and Forecast filters Dates. Does this make a difference?

Kind regards,

Neil

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

In the Dates Table there are blanks appearing in the Date column.  Remove those blanks rows.

  • NP2020's avatar
    NP2020
    Frequent Visitor
    5 years ago

    Hi Ashish_Mathur , that's great, thank you for all of your help.

     

    Kind regards,

    Neil

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      5 years ago

      You are welcome.