Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Friends,
I have added a new data Y21M10 to my chart, and after data/chart refresh, the value is reflected in the left before the value for Month7, 8 and 9.
I tried another way of sorting (sort descending) and it will be shown as M9,8,7 then 10.
Appreciate advice on how i can sort it in order of M7,8,9 then the latest data M10.
Thank you very much for your time and advice.
Solved! Go to Solution.
Hi amitchandak,
Thanks for your advice, i will take reference from the video link you have provided and work on the date creation.
Best Regards.
@Anonymous , As your numbers, is not 01, 02 it means in text sort
You need to create a sort column Y21M01
If you have the date you can create like
Format([Date], "\YYY\MMM")
Mark this as sort column for you column
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Hi amitchandak,
Thanks for your advice, i will take reference from the video link you have provided and work on the date creation.
Best Regards.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |