Forum Discussion
Logarithmic scaled scatter chart?
Can you check the data type that you're using for the x-axis? I'm using whole numbers in the example below and seeing the option to change the scale from linear to log. If you're not able to get it to work, one other workaround would be to create an additional column with the log value, then use that in the scatter plot.
Thanks,
Sam Lester (MSFT)
The column is of type decimal but I tried it with a fixed decimal and an integer column too. It comes from a Stored Procedure from a MS SQL Server, there it is a decimal(18,2).
An additional column which calculates the logarithm should be possible but shows the axis not the logarithm too? So it wouldn’t be good readable for a customer.
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 YuHi 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.
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
