Forum Discussion
Date and KPI Visual
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.
5 Replies
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.
Vallirajap can you allow me to access your file?
Thanks.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.
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.
