Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

2 data sets on same timeline

Hi,   I would like to compare the total actual cost per month with the payout amounts in a column chart. I managed to calculate the totalmtd but I´m not sure what to use on the time axis when one t...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    Please refer to my .pbix file.

     

    Best regards,
    Lionel Chen

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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Anonymous - Create a column in your first table:

 

Month = MONTH([Date])

 

Then you can relate your tables and then it shouldn't matter which you use in your visual.