How can I create a play axis by year and month

[Anonymous]

I have a dataset which has data from June 2022- Jan 2023 inclusive.

I want to have a play axis that starts from June and goes to January 2023. I created the axis by month and it starts at Jan and ends at dec and when I try by year it doesnt work either.

How Can I do that?

[ryan_mayu]

@Anonymous 

you need to create a column like 202206, 202207, 202208 and sort the column June 2022 by the new one

pls see the link below

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column

[Anonymous]

Thank you - I created the column as you said, converted it to whole number and then tried to sort the date column by the new column created but it doesnt seem to be doing it. Have I missed a step? Unless I create the play axis by the colum which has the 202206, 202207 etc.

[ryan_mayu · Accepted solution]

i did a test.

pls see the attachment below

[AQ230588]

Hi @ryan_mayu ,

I have similar issue where I want my play axis to begin at June2023 and end at March 2024 but I can not open your attchment to check the solution. Its giving me some credential error.

Can you please help.

Thanks

[ryan_mayu]

pls check if you can open this one

[AQ230588]

Thanks for sending this again, but I am still getting this error: "Failed to Decrypt Credentials: The data source credentials could not be decrypted. Please restart the program. If you continue to see this message, you can clear your credentials by clicking on the Clear Permissions button". I clicked that buttong but nothing happened.

[ryan_mayu]

pls try again

[Anonymous]

I see. Thats perfect, thank you!

[ryan_mayu]

you are welcome