Forum Discussion
Week data graph for several values
Hello Gurus, Didnt managed to find a solution for the following: I am working with PBI and need to display weekly data on the line chart -> currently data is being displayed by day. Using w...
create a new column in your date table called week,, like week=weeknum(datetable[date],2) create two other columns call year=year(dateable[date]) and month=month(datetable[date]) then in the report builder, drag this week field onto year field, then do the same to the month.