Forum Discussion
Quarto
2 years agoRegular Visitor
Sum data within a date range
Hello Community! First time poster here. I have read the guidance on how to ask questions so hopefully I have provided enough information - but please let me know if not! My data looks like t...
- 2 years ago
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.
lucadelicio
2 years agoImpactful Individual
Hi, Please put the pbix file (better) or the data file xlsx on wetransfer.com, and the image of the result that you want.
So the community will help you easly.
Thank you