cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Months Order by

hi,

i have a slicer with months list, sorted on descending order

for example:

Dec

Nov
oct

same if it will be numbers:

12

11

10

the problem, now we are on January, the List is now

Dec Noc Oct Jan

i created a calculated column -if jan then 1 if dec then 2 etc... to sort it correctly

the problem is that i need to change this calculated column every new month

 

is someone have an idea how to sort it?

thanks!

6 REPLIES 6
Highlighted
Memorable Member
Memorable Member

Re: Months Order by

Hi @MP_123,

 

You could create condition column in Query Editor for 12 months, but i dont understand "change this calculated column every new month"?

Highlighted
Microsoft
Microsoft

Re: Months Order by

hi @tringuyenminh92

what i meant is that:

if now we are on January so the calculated Column will be

Jan - 1

Dec - 2

Nov - 3

etc..., Feb will be 12 because it will be the last.

but when we will get to February, its value should be 1, Jan 2 and Dec 3

 

 

Highlighted
Memorable Member
Memorable Member

Re: Months Order by

Hi @MP_123,

 

I don't know what you are doing with your if statement or first or last or anything, but let me show it as below:

Screenshot 2017-01-18 20.01.22.png

 

Highlighted
Microsoft
Microsoft

Re: Months Order by

@MP_123

 

I think you suppose to have a month number column in your source table. You can add a rank column below:

 

Month Rank = 12 - Month(Today()) + Table[Month Number]

So the current month will be 12, previous month will be 11......

 

 

Then you just need to sort the Month Name based on above Month Rank in descending order.

 

Regards,

Highlighted
Microsoft
Microsoft

Re: Months Order by

@v-sihou-msft

hi, thank you!

I actually don't understand

let's say we are in february

month rank = 12 - 2 +2 =12

but for January = 12 -2 +1 =11

Dec ? = 12 -2 + 12 = 22

 

the Sort isn't good that way. or am i missing something?

thanks!

Highlighted
Microsoft
Microsoft

Re: Months Order by

i want that the rank of DEC will be 10... this month should come after january

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors