Date and KPI Visual

[alvin1999]

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.

[Vallirajap]

@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.

pvalliraja21@gmail.com

Did I answer your question?

Mark my post as a solution, this will help others...!

Hit the kudo also,

Thank you.

[Vallirajap]

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

Drive file 

Did I answer your question?

Mark my post as a solution, this will help others...!

Hit the kudo also,

Thank you.

[alvin1999]

@Vallirajap can you allow me to access your file?
Thanks.

[Vallirajap]

@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.

[alvin1999]

@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.