How to prepare data for chart

[ZYTOMEEN]

Hi, I have problem, I'm trying to create chart as on the picture but I cannot create file in correct way as I cannot add a control points i n Y axis. How to do this? 

[Deku · Accepted solution]

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

[v-pnaroju-msft]

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.

[v-pnaroju-msft]

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.

[v-pnaroju-msft]

Thank you, @Deku, @rajendraongole1, for your response.

Hi ZYTOMEEN,

We would like to check if the solution provided by @Deku and @rajendraongole1 has resolved your issue. If you have found an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.

If you found the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to similar queries.

Thank you.

[rajendraongole1 · Accepted solution]

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.

[Deku · Accepted solution]

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