How do I make a line graph that displays item by count(item)?

[paulsm4]

This should be INCREDIBLY simple ... but I haven't been able to figure out how to do it:

* I have a table of "batches".

* The same batch will have multiple rows, each row has a "state" and a "duration".

* I want to display a graph showing the #/rows that took 55 seconds, 85 seconds, ...

* I'd like the graph to show one line for "VALIDATION" rows, and a second line for "REVIEW" rows.
Q: How do I accomplish this (create the line graph visualization) in PBI Desktop?

EXAMPLE DATA:

Batch ID	Batch State	Duration (Seconds)
BI4FF8	VALIDATION	55
BI4FF8	REVIEW	85
BI4FF8	VALIDATION	176
BI4FF8	VALIDATION	4
BI4FF8	VALIDATION	7
BI5040	REVIEW	2
BI5040	VALIDATION	94
BI504F	REVIEW	3
BI504F	VALIDATION	123
BI5054	VALIDATION	73
BI5054	REVIEW	3

[MFelix · Accepted solution]

Hi @paulsm4 ,

For this you need to setup your line chart in the following manner:

• X-Axis
  • Duration
  • If you need you cna use the categorical instead of continous axis
• Y-Axis
  • Measure  = COUNTROWS(Table)
• Legend
  • Batch State
• You can also turn on markers and labels if you want

this will give you the following result:

Categorical axis

Contiuous axis