Forum Discussion

Koopakiller's avatar
Koopakiller
Regular Visitor
10 years ago

Logarithmic scaled scatter chart?

I am pretty new to Power BI and have some trouble with a scatter chart. The x-axis should be logarithmic scaled but I can only set it to linear.     What am I doing wrong?   PS: It's a ger...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi Koopakiller,

 

Based on my test in Power BI Desktop version 2.36.4434.381 , if the data stored in SQL Server database is decimal(18.2), when we get data from this data source, and place the decimal data type field in X-axis, the "Log" option is available in Scale Type property. See:

 

 

 

In your scenario, I would suggest you download and install the latest Power BI Desktop version   to check if issue persists.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Koopakiller's avatar
Koopakiller
Regular Visitor
10 years ago

Hi v-qiuyu-msft,

 

thanks for your reply. I installed the newest version, but this time in English. Now I can use Log as the axis type.

 

For now, I need only a chart with positive logarithmic shown values. I would like to know if it is possible to configure a chart to something like that?

I tried to use two columns with positive and negative values but that does not work. The Log option is missing again.

But it seems to be no problem if the values are all negative.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    10 years ago

    Hi Koopakiller,

     

    BAsed on my test, if X-axis and Y-axis values contain negative values, and we have placed field in Details or Legend, the "Log" will disappear under Scale Type option. Please check if you have added any filed in Details or Legend properties.

     

    Best Regards,
    Qiuyun Yu

    • Koopakiller's avatar
      Koopakiller
      Regular Visitor
      10 years ago

      Hi v-qiuyu-msft

       

      I tried to add a new data source with some negative and positive numbers and set the X and Y Source of a scatter chart. I did not set a detail or legend field but the Log option is still not available. If I set a legend or details field it still not appears.

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        10 years ago

        Hi Koopakiller,

         

        In a scatter chart, if only X Axis and Y Axis properties have values(both negative and positive), only one data point displays in the chart as it's aggregated. In this scenario, Log option is available for X Axis Scatter type. But if we placed any field in Details or Legend property, Log option is not available. Please check attached .PBIX file.

         

        Best Regards,
        Qiuyun Yu