Solved: Month is not change in to a calendar format

Anonymous · ‎10-07-2021

Hi,

I have created a Powerbi dashboard and it is working fine. whereas , the Month column from one table has calender symbol and another Month from another table doesn't have that symbol,

Why is this difference am i missing something ?

Kindly Help.

@v-jingzhang

Tahreem24 · ‎10-07-2021

@Anonymous , Have you created relationship with the Month Column with some other table? If yes, so in this it won't appear like Date Symbol but functioning like Date. I demostrated in the below screenshot i.e. before and after relationship creation.

P.S. Make sure that you have also checked that Month in your table as Date type.

Before RelationshipAfter Relationship

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

Tahreem24 · ‎10-07-2021

@Anonymous , Have you created relationship with the Month Column with some other table? If yes, so in this it won't appear like Date Symbol but functioning like Date. I demostrated in the below screenshot i.e. before and after relationship creation.

P.S. Make sure that you have also checked that Month in your table as Date type.

Before RelationshipAfter Relationship