Forum Discussion
Issues creating Line charts with multiple datasources...
I am missing something fundmental here.
I am trying to create a line graph with data from seperate data sources. Please See screen shot
In this case, I am looking at the change of the number of parcels
Technically it IS in a line, but just a vertical one. As I ad more spreadsheets in, this is not going to work for me. I want to see it on the horizontal. If this was all in the same spreadsheet, it would be VERY easy to make the line graph, but I need to make from original separate data sources.
Any ideas on what I am doing wrong? Thoughts?
Kind regards,
Create/ Maintain a seperate table with all dates as primary key. then link it to your fact tables using the date in respective tables (LGA_2014_NOW and LGA_2017_NOW)
Use the date from Date table for axis. and change the type by clicking date in axis and changing the type from Date Hierachy to date field name.
The reason for maintaining a date table is you have multiple fact table and you should be able to link them.
3 Replies
You dont have a date axis. Create a date field and map it to the axis.
Thanks for you advice but I am still having problems.
I gave the rows in each data source an arbrtity date. 1/11/2014 and 1/11/2017 - I am still confusing the the line chart. It only shows one of the years though they are both different.
I can't supply at he actual BI file and data sources unfortunaltley. Any other ideas I could explore?
Create/ Maintain a seperate table with all dates as primary key. then link it to your fact tables using the date in respective tables (LGA_2014_NOW and LGA_2017_NOW)
Use the date from Date table for axis. and change the type by clicking date in axis and changing the type from Date Hierachy to date field name.
The reason for maintaining a date table is you have multiple fact table and you should be able to link them.
