Customize axis values on the logarithmmic scatter chart

[bigk]

Hello

I need to use a logarithmic scatter chart because of value distribution. The problem is that default PowerBI axes data labels are far from perfect. They are showing too big numbers and viewers cannot understand real value of the point unless it is shown separately.  You can see on a chart that a point with a value of 25 is between 10 an 100 which is very unclear. 

Is there a way to customize axis labels so that could see values that are much closer to the points? In the attached image you can see that points have x-axes values as labels, but in reality there are different labels (numbers 1-10), so viewers cannot understand true impact values. I've also added a handwritten axis values how i see them. 

Any crazy and non-standard ideas (like overlays, hidden values, helper table hacks, etc.) are appreciated.

Thanks.

[bigk · Accepted solution]

Thanks for suggestion. I've ended up goind with my original thought and building a frankenstein. There are 3 layers of the same scatter plot. One is with white circles, another is with numbers ad third one has constant lines. I've adjusted transparency and sizes to achieve that.

This is super disappointing that i have to build such frankenstein to achieve basic visualisation that modern tools should have. Thanks everyone for your ideas.

[v-veshwara-msft]

Hi @bigk ,

Thanks for reaching out to Microsoft Fabric Community.

The native scatter chart in Power BI does not support customizing tick marks on a logarithmic axis. When log scale is enabled, the axis automatically displays values based on powers of 10, and intermediate values such as 2, 5, 20, or 25 cannot be manually configured.

For better clarity, you may use tooltips to display the exact value of each point.

If you require full control over logarithmic axis ticks and formatting, a custom visual such as Deneb can be used, as it allows explicit configuration of the scale and tick values.

You may also consider submitting this as an idea in the Fabric/Power BI Ideas forum so the product team can review it for future consideration. If you do so, please feel free to share the link here so other community members with similar requirements can review and upvote it.

Please reach out for further assistance.
Thank you.

[v-veshwara-msft]

Hi @bigk ,

Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.

Additionally if you have submitted the Idea, could you please share the link here so that it can get more upvotes from users with similar requirements.

Thank you.

[JamieHolding]

If you want specific points could you add reference lines in the Analytics pane?

[bigk]

Hi @JamieHolding

Thanks for suggestion. Reference line will add a line visible on the chart. Unfortunately this won't work for me. I need only a data label on axis to be visible.

[bigk]

You mean like this? This does not look good As the numbers are not on axis and also they are misaligned to left or right because it is not possible to put data lables in the center of the line.

[JamieHolding]

- Set a reference line on the x axis

- Set the data label to appear under

- Set the transparency of the line to be 100%

And now you have a label with no line