Forum Discussion

gelseytanse's avatar
gelseytanse
Frequent Visitor
8 years ago
Solved

Overlay/Combine Line Charts

I am trying to achieve a visualization of multiple lines graph to show: - salesman's monthly average selling rate (ASR) - company's overall monthly average selling rate Objective is to compare the...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi gelseytanse,

     

    I would suggest you add them all in one visual. Please check out the demo in the attachment.

    AA =
CALCULATE ( AVERAGE ( Table1[ASR] ), 'Table1'[SalesmanName] = "AA" )

    BB =
CALCULATE ( AVERAGE ( Table1[ASR] ), Table1[SalesmanName] = "BB" )

    Company = AVERAGE(Table1[ASR])

    Overlay_Combine_Line_Charts

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi gelseytanse,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale

gelseytanse's avatar
gelseytanse
Frequent Visitor
8 years ago

Hi Dale,

 

Thanks for the solution! 

 

Gelsey