cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Start currve with value

 

StartWithMai.PNG

I just want my curve to start at MaI but as it's the lowest value it's still at the end of the curve how can you make sure that started with May ? anyone can help ?

1 ACCEPTED SOLUTION
Johanno
Responsive Resident
Responsive Resident

Hi, you could create a date table and a relationship to your months and use that as your axis. Or you could create a new column and translate to month names to numbers in the correct order (SWITCH function). But I think the easiest way is:

1. Go to Home - Edit queries

2. If your months are in the correct order in the table - create an index column 1, 2, 3 etc.

3. Close and apply

4. Back at the report, select your month column, Modeling and Sort By column: Index

 

/Johan

View solution in original post

3 REPLIES 3
Johanno
Responsive Resident
Responsive Resident

Hi, you could create a date table and a relationship to your months and use that as your axis. Or you could create a new column and translate to month names to numbers in the correct order (SWITCH function). But I think the easiest way is:

1. Go to Home - Edit queries

2. If your months are in the correct order in the table - create an index column 1, 2, 3 etc.

3. Close and apply

4. Back at the report, select your month column, Modeling and Sort By column: Index

 

/Johan

View solution in original post

Anonymous
Not applicable

Thank's for the quick answer, it working well.

Anonymous
Not applicable

Thank's for the quick answer, it working well.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.