Forum Discussion
Line chart to map relationships
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 |
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
3 Replies
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
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
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
