Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Relationship between tables help

Hello Community. I have multiple tables with this format, each from different facebook pages.

 

idlikes_countcreated_timecomments_countshares_count
134630197899_13855458393912009-09-23T17:23:52+000030
134630197899_13463497789962010-02-09T21:13:29+000030
134630197899_292605132899102010-02-09T21:34:23+000020
134630197899_30839074911082010-02-15T19:51:40+000010
134630197899_31746085289912010-02-22T20:53:49+000001
134630197899_32441785226502010-02-24T13:47:37+000000
134630197899_341595679168122010-02-26T14:14:39+000040
134630197899_35186228357622010-03-04T22:10:02+000020
134630197899_1015011725032010412010-03-05T13:39:08+000000

 

I want to make a report with the "date" as the X axis and the "likes count" as the Y axis but I wish to have multiple bars with different "likes count" from different tables so I can show the comparisson between them.

 

I have tried to make a relationship "1 to Many" from the id column in a table to the "created time" column in another table but when I do this the report can no longer use the Date Hierarchy which makes the report really messy.

 

Help please

1 ACCEPTED SOLUTION

Hi @Anonymous,

 

You need to add the like counts from other tables. Please check out a demo here.

Relationship_between_tables_help

 

 

Best Regards,

Dale

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

View solution in original post

3 REPLIES 3
shebr
Resolver III
Resolver III

Hi @Anonymous

 

If you have multiple data sets similar to the one shown, what you want to do is the create a date table and point all your data sets to that date table and select the date from the date table as your axis. See below:

 

1. Watch the following video to create a date table in seconds! https://youtu.be/vJ7xNUK8sQE

2. Connect all your data sets to the date table in the relationships tab

3. Select date from the date table as the axis value

4. Select your 'like count' from different data sets. Perhaps create measures from them and name them differently.

 

Let me know how you get on.

 

Thanks

 

shebr

Anonymous
Not applicable

Thanks for the response. 

 

I have created my Date table and have created the relationship between the tables. But it ends up looking like this:

 

image.png

Hi @Anonymous,

 

You need to add the like counts from other tables. Please check out a demo here.

Relationship_between_tables_help

 

 

Best Regards,

Dale

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.