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 are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.
If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.
Thank you.