Linking multiple sheets via date

[Anonymous]

I have pulled in multiple data sources from SharePoint 365.

I am trying to build some stacked visuals as well as pie charts.

Each sheet is unique in what it captures, except for Id field and date.

I have tried creating a date table and linking them all to it via relationships.

When I do this, the chart is blank. (date as axis and 'count of ID as value)

I can use one of the sheets date field and count and it looks great, add another sheets ID count into value and it WILL show up, but only as the total sum consistently each month.

I have killed myself trying things and searching reddit and on here for help.

I hope some one can help out.

[parry2k]

@Anonymous  can you share sample data and expected result, will get you the solution. Reading at requirement and it look like something easy and not sure why it is not working for you.

[Anonymous]

sample of results I should haveSample of data

[Anonymous]

I am trying to get all these tables I pulled in to link to a single date field. I then am counting them by iD. This way I can see how many 'items' in each table were created over a time frame.

[Anonymous · Accepted solution]

Figured it out!!

While I had edited the fields to all match date types. I then went into each table in query edit....the fields were NOT date type there.

Transformed them there, linked to date table...BOOM! all is well.

[BANU]

I need to link dates from multiple sheets to create one slicer , but that's not working inspite of creating relationship

, Also all the dates have same date data type .

plz assist