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
revansh
Helper IV
Helper IV

LINE and CLUSTER Graph

Hi,

 

My date is in 2 tables as:

TABLE1:

STATE MONTH ACTUAL

NJ         APR          2

NY        APR          4

KY        APR          3

NJ         MAY          1

NY        MAY         2

KY        MAY         1

NJ         APR          2

NY        APR          2

KY        APR          2

 

TABLE2:

 

MONTH   TARGET

APR             10

MAY            12

JUN             15

 

WHEN I JOIN 2 TABLES :

 

MONTH   ACTUAL TARGET

 APR         9                10

 MAY        4                12

JUN           6               15

 

BUT WHEN I CHANGE ABOVE TABLE TO  LINE AND CLUSTER GRAPH. TARGET COLUMN IS ASKING FOR AGGREGATION.

 

MONTH   ACTUAL TARGET

 APR         9                37

 MAY        4                37

JUN           6               37

 

HOW CAN I JOIN MY FIRST 2 TABLES TO GET TABLE3 AS RESULT.

 

tHANKS

 

 

5 REPLIES 5
v-qiuyu-msft
Community Support
Community Support

Hi @revansh,

 

In your scenario, you needn't to join those two tables. You can just create a relationship between those two tables based on Month, then you can drag the Month from Table2 to x-axis of the chart, Actual and Target with Sum aggregate function as chart values. 

 

q1.PNGq2.PNG

 

For details, you can download attached pbix file to have a look. 

 

Best Regards,
Qiuyun Yu 

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

Hi v-qiuyu,

 

      I will have future dates in Table2. if i pull date from TABLE2, graph is shoiwing future months even though there are no records in table1.

 

Thanks

 


@revansh wrote:

Hi v-qiuyu,

 

      I will have future dates in Table2. if i pull date from TABLE2, graph is shoiwing future months even though there are no records in table1.

 

Thanks

 


Hi @revansh,

 

This should be a different issue from the original one, as your first post doesn't mention the future date column. 

 

So I think the sample data should be changed now. Please share the new sample data and show us the example to clarify the issue. 

 

Best Regards,

Qiuyun Yu 

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

Hi @revansh,

 

If the original issue is fixed now, would you please close this thread? 

 

Regarding your second issue, please create a new thread and share corresponding data and expected results. 

 

Best Regards,
Qiuyun Yu 

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

I would use a slicer to filter to actual months only

 

line and cluster.JPG

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.