Reply
Frequent Visitor
Posts: 6
Registered: ‎02-11-2019
Accepted Solution

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 ?


Accepted Solutions
Highlighted
Member
Posts: 56
Registered: ‎03-11-2018

Re: Start currve with value

[ Edited ]

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


All Replies
Highlighted
Member
Posts: 56
Registered: ‎03-11-2018

Re: Start currve with value

[ Edited ]

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

Frequent Visitor
Posts: 6
Registered: ‎02-11-2019

Re: Start currve with value

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

Frequent Visitor
Posts: 6
Registered: ‎02-11-2019

Re: Start currve with value

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