Forum Discussion
Power BI Scatter Chart X-Axis Alignment Statement
How to sort on Power BI scatter charts only by X-axis without being affected by the legend?
Except for the legend, they are sorted well in the order of the X-axis (Year/Month/week), but if you put the legend, they are grouped according to the legend and then sorted in the order of the X-axis time.
You have set the x-axis alignment to the three-point setting at the top right of the current chart, but the alignment does not apply.
By any chance, is there a way to set the legend to reflect only in color and not affect the X-axis alignment?
Also, is there a solution to the fact that the scatter chart is hierarchically visible on the X-axis?
The current X-axis
January 2025 : February 2025 : March 2025
It works in this way, but it's different from a typical histogram or a hierarchical chart of a line graph. The x axis I want is as below.
December : January February March April
2024 : 2025
If you let me know how to do either of them, please answer. If not, I would like you to let me know how to bypass.
Hello 김기만
The similar kind of issue I faced. I turned on the Show blank values. Please take look at below image. How to turn on select the visual->Formatsettings->Y-axis->Values->Show blank values (ON)
It works for me. Try in this way and let me know if it works.
Thanks!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
2 Replies
Hello 김기만
The similar kind of issue I faced. I turned on the Show blank values. Please take look at below image. How to turn on select the visual->Formatsettings->Y-axis->Values->Show blank values (ON)
It works for me. Try in this way and let me know if it works.
Thanks!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!Thank you for your answer
