Forum Discussion

Helper IV

9 years ago

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 ...

Community Support

9 years ago

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.

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

Best Regards,
Qiuyun Yu

LineAndClusteredChart.zip43 KB

revansh
Helper IV
8 years ago
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
- pawel1
  Kudo Kingpin
  8 years ago
  I would use a slicer to filter to actual months only
- v-qiuyu-msft
  Community Support
  8 years ago
  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
  - v-qiuyu-msft
    Community Support
    8 years ago
    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