Forum Discussion
Solved
Resource Allocation Report
Hello, I need a help for creating a resource allocation report in a monthly and weekly timeline. We have 3 tables, Allcoation, Project and Resource Allocation table has below fields --...
I'm assuming you want to show this overtime i.e as a line chart?
You can use the date field as the axis and the allocation % field as the values. Depending on how you represent the data you can use the raw date field or select 'Date hierarchy' this will allow you to view it as Year,Quarter,Month or Daily.
You can create a field using the DAX 'today()' function and create a relative date filter. This will allow you too select 'last,this or next' in weeks,months or years.
You can create two line charts one Monthly and one Weekly both with separate filters (based on above method) to achieve this.
Hopefully this makes sense and helps!