Forum Discussion
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...
I did something very similar to this once and put it in the Quick Measures gallery as Hours Breakdown.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Hour-Breakdown/m-p/625085#M306
You could potentially do it as a measure but might also have luck creating a DAX table, just depends. DAX and Power BI are really built and optimized to summarize raw data, not invent data from summarized data. You're kind of going about it backwards.
2 Replies
- Greg_DecklerCommunity Champion
I did something very similar to this once and put it in the Quick Measures gallery as Hours Breakdown.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Hour-Breakdown/m-p/625085#M306
You could potentially do it as a measure but might also have luck creating a DAX table, just depends. DAX and Power BI are really built and optimized to summarize raw data, not invent data from summarized data. You're kind of going about it backwards.
- Ferrol40Frequent Visitor
There are number of forms you can check out may be they might help also i have posted a similar question and waiting for replies
Forums that might help
Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community
Spread value across time between 2 dates - Microsoft Power BI Community
Solved: Re: Spread duration across month - Microsoft Power BI Community
My Question
Spread Hours across days and link to date table to... - Microsoft Power BI Community