Showing the wrong dates

[koningii]

I am using in the model a created calender table for the dates but somehow it shows the wrong dates in the graph. How can this be solved?

[v-chenwuz-msft]

Hi @koningii ,

Have you created a relationship between the data table and the calendar table?

Or is the x-axis of your chart not continuous?

If yes, you can try set the format of this graph.

If i misunderstood you, please share your pbix file without sensitive data.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@koningii , On single date table, One active one inactive join and two measure 

example

Started = CALCULATE(COUNTrows(Table]),USERELATIONSHIP(Table[IFC_ACT],'Date'[Date]),not(ISBLANK(Table[IFC_ACT])) )

Ended = CALCULATE(COUNTrows(Table]),USERELATIONSHIP(Table[IFC_PLAN],'Date'[Date]),not(ISBLANK(Table[IFC_PLAN])))

refer

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...