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...
Hi, Max_Z the default PBI date hierarchy doesn't support week drill down, you can however create a customized date hierachy one as year->month->week and then use this new field to create your visuals. Thanks Andrew
- 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.
ml_andrew thanks, tried that but it is not really helps to the need....
Still need to use Excel charts...
I need ability to have an option to display data in graph per specific weeks as it shown in the Excel graph in hte beginning of the post...
Currently PowerBI agreggrades the data and shown data for whole chosen period... and not the data by the week chunks...
