Forum Discussion

Max_Z's avatar
Max_Z
Microsoft Employee
6 years ago

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 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:

Need Help
Show and Tell
Tips and Tricks

10 Replies

    • Max_Z's avatar
      Max_Z
      Microsoft Employee
      6 years ago

      Hi,

       

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

  • ml_andrew's avatar
    ml_andrew
    Regular Visitor
    6 years ago
    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
      • ml_andrew's avatar
        ml_andrew
        Regular Visitor
        6 years ago
        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.