i have a slicer with months list, sorted on descending order
same if it will be numbers:
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?
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
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.
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?
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!