Multiple tables graphed on one line chart

[Jaydis]

Hello,

I have multipe excel files, each containing a list of users in a system for a specific time period, which I'm importing as seperate tables. I would like to graph "count of users"(y-axis) by "date"(x-axis) on a line chart. So each table would be one data point on this chart. Is this possible to do?

P.S. I dont want to just sum the users in each file because I'd like to keep the chart interactive so I can pull up the user's names when I click on a data point.  

Thanks!

[Jaydis · Accepted solution]

I figured out how to make this work - I made a seperate table with all the dates and a reference number that I linked back to all the other tables. Then I graphed "Date" from that table on the axis.

[v-shex-msft]

Hi @Jaydis,

If you want to create graph with multiple table fields, you should confirm they has availed relationships so that power bi can summarize and analytics these data based on relationship.
After build relationship, you can create a line chart with date as axis and drag user column to value fields with summarize mode 'count'.

Regards,

Xiaoxin Sheng

[Jaydis]

Hi @v-shex-msft,

I've created a relationship between the usernames but if I graph the count of users they all end up displaying on the same date, even if I add date columns from both tables.

See screenshot (One table is 2014, one is 2015 but they are displaying only on 2014):

[v-shex-msft]

HI @Jaydis,

Please use calendar date as axis with normal mode(not hierarchy mode), it will show the line graph which you wanted.
Your chart has summary records to year level, maybe you can expand your axis to see more details.

Regards,
Xiaoixn Sheng