Get 2 subsets of a column as series on a line graph

[Anonymous]

Hey Everybody,

I have a Table with multiple sets of different tags, each tag has multiple entries based on the time the event occurred. For example the "button_clicked" tag will be mentioned 10 times each with a timestamp of when the button was clicked, and that timestamp may not be a unique entry.

What I would like to do is have a graph that shows the value of two of these tags within a time period like below:

How can I achieve this?

[Anonymous]

Hi @Anonymous,

Go to Visualizations => select Line chart as per below.

Where you see Axis (I have cities om below) add your time, dates , whatever you want to see on the bottom of the chart. 

Add your values to Value 

 This should help you to have the chart.

Please mark as solutions if my answer helped and give kudos.

Best regards,

Alin Oprita

[Anonymous]

Hi @Anonymous 

My situation is a little different.

Your instruction "Add your values to Value" doesn't work for me because all my values are within 1 column. I can filter the graph to see each set of values I am interested in but I cannot see both at the same time.

[v-gizhi-msft · Accepted solution]

Hi,

It works well here:

See my attached pbix file.

Best Regards,

Giotto

[Anonymous]

Hi @v-gizhi-msft ,

Your solution works, I think the difference was adding tagnames as a data field in Legend.

Thanks again,

Francesco