Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Formatting xaxis to show only weekly timestamp

Hi PowerBI champs,   Currently I am trying to plot daily information on a line graph and using the categorical x-axis I am getting all the data point timestamp on my axis.   But I only need to sh...
data protection
NewbieYR's avatar
NewbieYR
Frequent Visitor
4 years ago
Assuming you have a datetable already. 
WeekNum = FORMAT(DateTable[Date],"WW")
First day of the week = Format(CALCULATE(min(DateTable[Date]),filter(DateTable,DateTable[WeekNum] = earlier(DateTable[WeekNum]))),"MM/DD/YY")
This will give you the date of each Monday 🙂
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi NewbieYR ,

     

    Thanks for your inputs, but I am not looking to plot the graph on weekly aggregation.

     

    I want that we plot all the days information, but in the axis only show week time stamp and not all the days timestamp.