different Excel worksheets

[rthomasb]

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

[davenportmb]

I have the exact same problem. Did you ever figure out where the problem was?

[Greg_Deckler]

Any chance you can post screen shots or sample data?