compare a measure from fact table for different timestamp in line chart

[Anonymous]

Hey, I have been tasked to change the data model for existing Power BI report and iIm facing roadblock while recreating below chart. The below screen shot is from existing PBIX file where the data is stored in traditional format.

Problem Statement: Two tables New_BD_Fact_Current and New_BD_Fact_Prior are from single source Fact table (BD FactData). New_BD_Fact_Current contains data only for latest month and New_BD_Fact_Prior contains all data except of latest month.

Current field as in Axis visualization is bassically Expected Revenue from Current table and Prior as in Secondary values is Expected Revenue from Prior table.

Is there any simple solution to display this comparision from single Fact table itself, I have expected revenue measure in Fact table and Week number in Date dimension with both the tables relationship as DateID.

[lbendlin]

Instead of using the secondary axis (which has a very different scale than the primary axis) create a flag in your fact data that distinguishes between "current" and "prior" and then add that flag to the Legend well.