Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
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,
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |