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,

 

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

Koopakiller's avatar
Koopakiller
Regular Visitor
10 years ago

Hi all,

 

v-qiuyu-msft

I downloaded your file and selected the lower chart. The available scaling types for x-axis is still only "Linear":

If I remove "Column" from Details, I was able to set the scale type to Log. So it works how you described it. My mistake was that I included a 0 in my test data.

 

But I did not understand why I cannot set Details or Legend to use Log. Is there any explanation?

 

BeardyGeorge

Thanks a lot! Some time ago I played a little bit with R so it should be possible to me to use the script visual. After a short test I think it is more easy to use the R element instead of the build-in scatter chart for me. It is not so easy to figure out what I want but it is more powerful.