Time series using multiple datasets

[Anonymous]

Hello, 

I'm new to Power BI, so preemptive apologies if this request is lacking in necessary detail (or sense!) 

I am working with annual population data and would like to make a time series to show population change in working and non-working ages. However, I am getting stuck as each calendar year comes as a separate dataset. Is there a way to get Power BI to recognise that values from different datasets are related sequentially?

To make things more complicated, each calendar year's dataset comprises rows of small geographies (Area codes, below) that - when it comes to visualisations - I need to be able to aggregate into a range of larger geographies (i.e. to show population change for different area committees (second column), and for the whole region (all rows)). So I need to make sure any way of creating the sequence retains this geographical detail. 

I hope that makes sense. Any advice gratefully received 🙂 

[v-chenwuz-msft]

Hi @Anonymous 

You can try to add relationship between these data source and use the same column in visual. For example, AreaCode, in a bar chart, as the following show.

if i misunderstood your, please let me know and share your pbix file or expect result.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

Can you provide sample data or PBIX file and a depiction of the expected outcome? How are the years identified by rows?