Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Switch x-axis starting point

Hello all,

 

I want to switch the starting point of the x-axis in a scatter chart. Instead of it going left to right as the numbers get larger I want the smallest number to start on the right and the largest number to be at the left end. I've looked at te formats and I can only change the position of the y-axis. Is there any possibility of doing this?

 

Thanks.

1 ACCEPTED SOLUTION

Hi @Anonymous,

Baesd on my test, you could format the [Behavior] as text and sort the value descending.

1.PNG

You could also download the pbix file to have a view.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
v-danhe-msft
Employee
Employee

Hi @Anonymous,

Could you have tried to use the Sort Decending function with your visual?

1.PNG

Result:

1.PNG

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hello @v-danhe-msft,

 

I checked and I do not have that as an option

 

Capture.PNG

 

I have that option for other charts but for the scatter plot I do not

Thanks

Hi @Anonymous,

Could you please offer me some simple data that I could have a test?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hello @v-danhe-msft,

 

Here is some sample data. I had Behaviour as the x-axis and Performance as the y-axis.

 

First NameLast NamePositionDepartmentBehaviorPerformance
JoeDirtAccounting ManagerFinance55%75%
CameronDiazEngineerEngineering75%85%
MelGibsonAccounting SupervisorFinance65%65%
DianaMcLeanAccounting ClerkFinance68%55%
StephenAveryHR ClerkHR81%80%
VirginiaReesExecutive AssistantFinance82%81%
JenniferReidControllerFinance83%82%
RobertScottDirector of FinanceFinance85%83%
JosephBlackDesktop SupportIT87%86%
JoshuaYoungBusiness AnalystIT93%87%
IanBrownApplication SupportIT63%98%
NeilPayneIT ManagerIT80%100%
RosePeakeHR RepresentativeHR63%92%
RuthGrayHR ManagerHR60%95%
RyanGillDeveloperIT73%97%
AbigailBellAccounting ManagerFinance68%60%
CarlEllisonEngineerEngineering81%75%
AdamAbrahamAccounting SupervisorFinance82%85%
MelanieWelchAccounting ClerkFinance84%65%
WarrenBerryHR ClerkHR85%55%
GavinGibsonExecutive AssistantFinance73%80%
MariaYoungControllerFinance76%81%
NatalieSutherlandDirector of FinanceFinance65%82%
PippaMcGrathDesktop SupportIT75%83%
FionaGillBusiness AnalystIT86%86%
RachelHamiltonApplication SupportIT88%87%
SoniaArnoldIT ManagerIT90%98%
EdwardRutherfordHR RepresentativeHR72%100%
TrevorLangdonHR ManagerHR81%92%

Hi @Anonymous,

Baesd on my test, you could format the [Behavior] as text and sort the value descending.

1.PNG

You could also download the pbix file to have a view.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hello @v-danhe-msft,

 

It worked. When I downloaded your pbix file it told me I could not open it because I have an old version. So I updated Power BI and it is all good.

 

Thank you.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.