Forum Discussion

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

Tips and Tricks

Microsoft Employee

6 years ago

ml_andrew Ho do I do that ?

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.

Max_Z
Microsoft Employee
6 years ago
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
  Regular Visitor
  6 years ago
  
  got confused, isn't this what you are looking for?
  - Max_Z
    Microsoft Employee
    6 years ago
    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.

Related content