Line Chart- Multiple Lines Each Based on Same Value but by different time events

[pswigert]

If my data looks like:

ID          EventA            EventB            EventC

1           5/3/2016        5/7/2016          5/9/2016

2           5/3/2016        5/2/2016          6/8/2016

3           5/3/2016        5/1/2016          9/9/2016

4           5/3/2016        7/7/2016          11/4/2016

5           6/11/2016      6/14/2016        11/13/2016

Is it possible to have a line chart where the y axis is the counts of the IDs and the axis is just the day, but three lines: counts of eventA, counts of eventB, and counts of eventC on that day?

[v-sihou-msft · Accepted solution]

@pswigert

In this scenario, since you need to get the count id group on Event and Date, you need to unpivot all other columns in Query Editor.

Then you table will look like below:

Now you can just set the aggregate type into "Count (Distinct)" for ID.

When using chart visual, just dray the "Attribute" in Legend.

Regards,

Simon Hou

[Baskar]

Sorry dude we cant do like this .

but we can do one thing , set hierarchy but it won't help on your case .

i thing u have to understand dude.

multiple dimension at single can't possible i think so.

sorry