Forum Discussion

BInewbie's avatar
BInewbie
Frequent Visitor
8 years ago

Scatter Plot - Categorical X Axis issue

 The september 2018 release allows us to use categorcal variables on the X axis of a scatter plot.

 

I have achieved this with year along the x axis, and an index value on the y axis. However as soon as I add company to details, the visual breaks.

 

Error: Remove details to display x and y axis pairs. Alternatively, you can keep details and set a summarisation for x and y axis.

 

Im trying to achieve a dot for every company (will only appear in one year) with their corresponding index value. Any thoughts?

Need Help

3 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi BInewbie,

    Based on my test, I could reproduce your problem, I suggest you to sum your [ID] and [Year], then you could see the correct result.

    Result:

     

    Regards,

    Daniel He

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi BInewbie,

    Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

     

    Regards,

    Daniel He

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi BInewbie 

     

    Here is Scatter Plot - Categorical X Axis chart which will help to get categorical variable on X-axis and index value on Y-axis.

     

    Scatter Plot - Categorical X Axis .PBIVizEdit.comScatter Plot - Categorical X Axis .PBIVizEdit.com

     

     

    Download link for the custom visual file in this page

    https://pbivizedit.com/gallery/scatter-plot-with-categorical-data 

     

     

    This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

    • anyone, irrespective of technical skills, can create their own visuals
    • 15 minutes to create a visual from scratch
    • opens up many additional attributes to edit (for e.g. labels, tooltips, legends position, etc)

    Give this a shot and let us know if you face any problem/errors.
    You can use the editor to modify your visual further (some modifications cannot be done in Power BI window and have to be in editor).

    Thanks,
    Team PBIVizEdit