topic Re: Showing the wrong dates in DAX Commands and Tips

Showing the wrong dates

koningii — Fri, 07 Jan 2022 11:05:06 GMT

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?

amitchandak — Fri, 07 Jan 2022 11:27:41 GMT

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

v-chenwuz-msft — Tue, 11 Jan 2022 06:53:45 GMT

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.