Forum Discussion

bigk's avatar
bigk
Helper III
6 months ago
Solved

Customize axis values on the logarithmmic scatter chart

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...
Tips and Tricks
  • bigk's avatar
    bigk
    6 months ago

    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.

     

     

JamieHolding's avatar
JamieHolding
Resolver I
6 months ago

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

bigk's avatar
bigk
Helper III
6 months ago

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.

  • JamieHolding's avatar
    JamieHolding
    Resolver I
    6 months ago

    - 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

  • bigk's avatar
    bigk
    Helper III
    6 months ago

    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.