Week data graph for several values

[Max_Z]

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 weeknum function is not really helpfull as when I look on the month overview it shows weekly data agregated by whole month.

I need to see data by week (on month graph) - where data for each week in independent from previous week...

Currently I am using Excel table by a side, entring weekly data 

Is there any way to achieve the same result in the PowerBI ?

Attaching screenshot for better understanding,

PowerBI:

Excel table:

[ml_andrew]

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

[Max_Z]

@ml_andrew  Ho do I do that ? 

[ml_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.

[Max_Z]

@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...

[ml_andrew]

got confused, isn't this what you are looking for?

[Max_Z]

@ml_andrew not really... as mentioned in the beginning...

Currently I have to work with Excel table and PBI (that collects data from Kusto).
For my needs I collect results in PBI on weekly basis and manually put them to Excel and table looks like:

17-23/11/19	38.8%	37.5%	21.5%	2.2%
24-30/11/19	46.1%	29.2%	22.4%	2.3%
1-7/12/19	45.2%	28.7%	24.3%	1.7%

To get that data I set in PBI time slidet for these days (entire week) like that :

Hope it is bit clearer now...

Visual that I need to display is weekly results and not agregated data.

[Max_Z]

Any suggestion ?

[v-chuncz-msft]

@Max_Z 

It seems that you may take advantage of Drill down in a visualization in Power BI.

[Max_Z]

@v-chuncz-msft  Hi, any other suggestions ?

[Max_Z]

Hi,

It doesnt work.. in a dril down there is no option to have weekly points