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?