Forum Discussion
Showing the wrong dates
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?
2 Replies
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.
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
