Need help with adding 2 YOY data sets to 1 line graph

[v-tangjie-msft · Accepted solution]

Hi @RichOB ,

According to your description, here are my steps you can follow as a solution.

(1)  My test data is the same as yours.

(2) We can create calculated columns.

Overall Total % 1 = IF([Area]="South West" && [ProjectName]="St Leonards",[Overall Total %],BLANK())

Overall Total %2 = iF([Area]="South West" && [ProjectName]="Tom Jones",[Overall Total %],BLANK())

(3) Please refer to the image below to place fields to create a visual, please refer to my pbix.

Best Regards,

Neeko Tang

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