Line chart to map relationships

[at8]

Hi all

 I have two colums of Data and i would like a graph similar to what is attached to show the relation between the two columns. I am able to add the X axis but the Y axis automatically converts to count as it allows only numbers, but mine is of the type text.

How can i fix this?

Process Step	Machine
AA	M1
AB	M1
AC	M1
AD	M2
AE	M3

[TomMartens · Accepted solution]

@at8 please add additional products to the sample data. Is the order of processteps always identical?

Nevertheless, it is not possible to create a line chart with two categorical axis using the default Power BI line chart. i recommend that you are using the Deneb custom visual: https://deneb-viz.github.io/

Hopefully, this provides you an on how to tackle your challenge.

Regards,

Tom

[TomMartens]

Hey @at8 ,

what is the expected outcome, given the 5 sample rows you provided?

Given the machines, myassumption is this:

one line (M1) and

two points (M2 and M3)

Regards,

Tom

[at8]

Hi tom , I want visulaize the flow of a product across multiple machines when it follows the process steps. Like this, the intend is to add multiple products that go through these machines