Forum Discussion
How to prepare data for chart
- 1 year ago
Scatter plot doesn't allow two axis of categorical data
You could use a matrix and a measure that returns a •, and use conditional formatting to colour. Or you could use a matrix with a measure that returns a SVG.
Alternatively this could be created with deneb
This https://vega.github.io/vega-lite/examples/circle_github_punchcard.html could be modifed to do what you want. You can remove the size element and add a legend to get colours
- 1 year ago
Hi ZYTOMEEN -If the scatter chart approach does not work as expected, you can use:
"Dot Plot by MAQ Software" (Power BI Marketplace)
"Matrix Visual" with conditional formatting to simulate the dots.Hope this helps.
Hi ZYTOMEEN,
We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.
If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.
Thank you.