different Excel worksheets

Hi,

 

This is my first time using PBI.

 

I am hoping someone can please help me.

 

I have uploaded an excel with 3 worksheets. Each w/s is data for a different region (APAC/EMEA/USA). They all have the same column headings, with different data numbers below them and ave put into tables.

After I imported the Excel file, I am presented with 3 tables in PBI filter.  If I want to select 'total cases' by 'date' for APAC and select line chart, it works fine.

Howevr as soon as I want to create a chart diplaying the cases for all regions together on the line chart, then the data for EMEA/USA appears a linear straight line and represents a single repeating number.

Can someone possibly exlain what I'm doing worng here.

I just can't seem to fathom this out and there's not much help with 'filters' in the self help section?

 

Regards,

 

Rich