LINE and CLUSTER Graph

Question

Hi,&nbsp;My date is in 2 tables as:TABLE1:STATE MONTH ACTUALNJ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; APR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2NY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; APR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4KY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; APR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;3NJ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MAY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1NY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MAY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2KY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MAY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1NJ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; APR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2NY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; APR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2KY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; APR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;TABLE2:&nbsp;MONTH&nbsp;&nbsp; TARGETAPR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10MAY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12JUN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;WHEN I JOIN 2 TABLES :&nbsp;MONTH&nbsp;&nbsp; ACTUAL TARGET&nbsp;APR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;MAY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12JUN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;BUT WHEN I CHANGE ABOVE TABLE TO&nbsp; LINE AND CLUSTER GRAPH. TARGET COLUMN IS ASKING FOR AGGREGATION.&nbsp;MONTH&nbsp;&nbsp; ACTUAL TARGET&nbsp;APR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 37&nbsp;MAY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;37JUN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 37&nbsp;HOW CAN I JOIN MY FIRST 2 TABLES TO GET TABLE3 AS RESULT.&nbsp;tHANKS&nbsp;&nbsp;

v-qiuyu-msft · Answer

Hi&nbsp;revansh,
&nbsp;
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.&nbsp;
&nbsp;

&nbsp;
For details, you can download attached pbix file to have a look.&nbsp;
&nbsp;
Best Regards,Qiuyun Yu&nbsp;

revansh · Answer

Hi v-qiuyu,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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.&nbsp;Thanks&nbsp;

pawel1 · Answer

I would use a slicer to filter to actual months only&nbsp;

v-qiuyu-msft · Answer

revansh wrote:
Hi v-qiuyu,
&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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.
&nbsp;
Thanks
&nbsp;

Hi&nbsp;revansh,
&nbsp;
This should be a different&nbsp;issue from the original&nbsp;one, as your first post doesn't mention the future&nbsp;date column.&nbsp;
&nbsp;
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.&nbsp;
&nbsp;
Best Regards,
Qiuyun Yu&nbsp;

v-qiuyu-msft · Answer

Hi&nbsp;revansh,
&nbsp;
If the original&nbsp;issue is fixed now, would you please close&nbsp;this thread?&nbsp;
&nbsp;
Regarding your second issue, please create a new thread and share corresponding data and expected results.&nbsp;
&nbsp;
Best Regards,Qiuyun Yu&nbsp;

Forum Discussion

LINE and CLUSTER Graph

5 Replies

Related content

Line Graph Visual

My clustered column + line graph miscalculates a YearMonth comparison

Multiple line and clustered columns chart

Line Graph Errors

Cropped Graph (Line Graph)