Forum Discussion

ZYTOMEEN's avatar
ZYTOMEEN
New Member
1 year ago
Solved

How to prepare data for chart

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's avatar
    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

  • rajendraongole1's avatar
    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.