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? 

[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]

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]

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