Forum Discussion
Sum data within a date range
Hi think you are a little bit confused.
First of all you have 2 dates. Start and end.
So wich date you want to use to show in the stacked area chart?
If you use the start date the result will be this:As attachment the pbix.
For the second if you don't explain the way to split the FTE values in week how you can will do it?
Before go in power bi you have to set all the logical rules.
Then with the rules set you can go on power bi to do what you need.
The right visual for your data is wath you have yet built.
If you have a value with a range you have to use the gantt.
Hi Luca,
Apologies. Here is what I would like to see on the report. The first is a stacked area chart with FTE on the y-axis and the Date on the x-axis.
It would also be great if I could get something like the Gantt chart visual I used here but with a way to sum the FTE at intervals of one week, as I've added to the image below.
Thank you for your help with this!
Hi think you are a little bit confused.
First of all you have 2 dates. Start and end.
So wich date you want to use to show in the stacked area chart?
If you use the start date the result will be this:
As attachment the pbix.
For the second if you don't explain the way to split the FTE values in week how you can will do it?
Before go in power bi you have to set all the logical rules.
Then with the rules set you can go on power bi to do what you need.
The right visual for your data is wath you have yet built.
If you have a value with a range you have to use the gantt.