Forum Discussion
Using PowerBI for resource management
Thank you for your quick response! Do Ineed to create a spreadsheet for each view I want to show on the dashboard, or can the dashboard pull the info differently for each view I want to show? If not, do I need to create the same table on 3 different spreadsheets to pull into Power BI correctly?
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,
