Forum Discussion
Using PowerBI for resource management
Hi there, I'm trying to use PowerBi to create a dashboard for my department that will show assignments sorted in a couple different views: 1. by creative resources 2. by project name/initiat...
If the data to use is the same for each view and only change the visuals, you only need 1 spreadsheet.
With only 1 table (if this have all the data that you need) you can do it
Okay great - I'm going to try this out and I will let you know how it works, thank you!
In this scenario, since you want to group your data on different level, you just need to drag the data field you want to group on and the fact data into field, it will aggregate the fact data on corresponding level. And you can also click on the fact data field to edit the aggregation type.
Regards,
