Forum Discussion

richard-powerbi's avatar
richard-powerbi
Post Patron
6 years ago
Solved

Spreading data over time

Let's say I have a table with 3 columns:

Hours, StartDate, EndDate

 

If I want to show a graph with on the X dates and on the Y hours, how can I spread hours over time?

 

For example:

400, 2019-01-01, 2019-01-29

Graph with X on weekly basis should look like:

100, 100, 100, 100

 

Are there visuals that can do this? Or do I have to create seperate rows for every date in the data model devided by the amount of days? It would add tons of rows for every existing row. I hope there is a better solution...

 

 

2 Replies