Representing non-numerical values on a graph

[AndreasAh]

Hi,

I have a table that are representing a relationship between non-numerical values:

Reportnumber	Related Reportnumer
Y22-123	Y20-001
...	...

From other tables I can get a date when this report was generated. I would like to create a graph where:

• X-axis: date when report was generated
• Y-axis: A series where all relatedreportnumbers are connected (non numeric values)

Do you have any tips on how to achive this sort of graph?

Best Regards

Andreas

[amitchandak]

@AndreasAh , refer old solution

https://community.powerbi.com/t5/Desktop/Categorical-data-as-X-and-Y-axis/td-p/1589093

or

Charticulator Part 2 - Scatter with Shapes: https://www.youtube.com/watch?v=QIPsv5hNbqI

[AndreasAh]

thank you 🙂

Do you have any suggestions for how I can build a series with relatedreportnumbers?

Reportnumber	Related Reportnumer
Y22-123	Y21-321
Y21-321	Y21-268
Y21-268	Y19-123

Outcome should be as the graph in my question.

Best Regards

Andreas