Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team
Below is the screenshot of my table in which Months are showing in columns.
I would like month to be seen as "mmm-yy". I have been able to make new column for data using "
Is there a way to sort this as Jan-21,Feb-21 and so on?
Kindly suggest
Thanks and regards
RatanB
Solved! Go to Solution.
@Anonymous
You should add a column with "Mmm YYYY" then another column with SortColumn = INT ( FORMAT (Table[DAte],"YYMM") ) then sort by this:
Wat this video for instructions: https://www.youtube.com/watch?v=NlX7Cp2P0d4
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
You should add a column with "Mmm YYYY" then another column with SortColumn = INT ( FORMAT (Table[DAte],"YYMM") ) then sort by this:
Wat this video for instructions: https://www.youtube.com/watch?v=NlX7Cp2P0d4
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Anonymous
Have you try to convert date format from ribbon because in that case seperately sorting is not required.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
this format is not coming in my power bi? How to get this?
@Anonymous you can directly write this "mmm-yy" over there.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |