Forum Discussion
Representing non-numerical values on a graph
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
2 Replies
- amitchandak
Super User
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
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
