Line chart - Add lines based on table selection

[Aragorn]

Hi,

 I have a table of objects in the main report. These objects have a seperate table with historic data.

ex:
 Table 1:

OBJECT_ID	OBJECT_NAME
T001	Test Point 01
T002	Test Point 02
T003	Test Point 03

 
 And the History data table:
 

OBJECT_ID	RECORD_DATE	VALUE
T001	10/10/2022	5
T001	11/10/2022	7
T002	11/10/2022	3
T001	12/10/2022	8
T003	12/10/2022	1
T003	12/10/2022	2

and it goes on..

I also have a LINE CHART to show this history data.

IS it possible to generate the line chart based on the selection of objects from table1 ?
i.e
If you select T001 from the table, the chart would show values for T001. 
If you select T002 from the table, the chart would show values for T002.

But If you select T001 AND T002, there should be 2 Lines in the chart, 1 for each object.

We only have max 5 Objects, so If there's a way to give 5 measures as Y Values for the chart which somehow get values for each object..?

Is this something doable?

Please help! 
Thank you!

[v-yanjiang-msft]

Hi @Aragorn ,

According to your description, here's my solution.

The two tables are related with OBJECT_ID column.

Put RECORD_DATE in X-axis, VALUE in Y-axis and OBJECT_ID in Legend.

Result:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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

[Aragorn]

Hi, 
 Yes.. this works.
But Is there a way to show the "Average" of all when No object is selected, instead of showing all the lines?

In the data I have, there are 1000s of Objects. I want to show the average of  all when more than 5 objects are selected. If its less than 5, then the 5 lines should appear.

Sorry I forgot to mention that earlier.

Thank you so much!