Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have create a simple datatset for my scenario. Below is what I have tried:
1. Extracted Month and Year from Date column in date data type
2. Sorted the month column based on Month No
3. Created a measure called Total Amount
My question are:
1. How can I convert the Month and Year columns into date data type instead of text and whole number data type?
2. The KPI visual unable to display the latest month from the dataset if I selected Month column in the Trend Axis field. However, no issue if I selected Date column. I want to display Month data instead of the full date in dd/mm/yyyy.
Here is the PBIX file for testing:
https://drive.google.com/file/d/1DTL2A9eq-MflJCUborPcMP-WV_e_sHW3/view?usp=sharing
Thanks for your kind advise.
@alvin1999In my reply post, I share one pbix file. In that file, there are two columns, like year and month, in the below image. Go and see how that will be modified.
In rare cases, connect with me through email.
Did I answer your question?
Mark my post as a solution, this will help others...!
Hit the kudo also,
Thank you.
Hii @alvin1999,
Try this,
Using the date column to create a date group in this group, you can change the format to "yyyy" and then it will show only the year in the date datatype. in the same way you used in the month also.
Here is the output file
Did I answer your question?
Mark my post as a solution, this will help others...!
Hit the kudo also,
Thank you.
@alvin1999Now that I gave you access, please check
Did I answer your question?
Mark my post as a solution, this will help others...!
Hit the kudo also,
Thank you.
@Vallirajap I can access to the file now.
May I know are you convert the date format in Column Tools > change Date type to Date/Time > Format (type MMM for month and chose yyy in the drop down list) in table view?
For Month, I got
For Year, I got all the values are 1905
Can you guide me please? Thank you.
User | Count |
---|---|
89 | |
85 | |
66 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |