Excel to PowerBI Dashboard
Budget: $10 – $20 CAD
Dashboard Requirements:
1. Would like PowerBI to have a dropodown list just like column AI has and when it is selected the calculations will be the same as if it was done in Excel.
2. Have column AM to show $0 if it is #DIV/0!
3. Would like a KPI on to show LodgeName, Selected Day, Anticipated Food Cost, Target
a. Same thing for a selected Month and year
b. The KPI will show red or green if the variance is off between Anticipated Food Cost vs Target
4. Be able to print a report
1. Would like PowerBI to have a dropodown list just like column AI has and when it is selected the calculations will be the same as if it was done in Excel.
2. Have column AM to show $0 if it is #DIV/0!
3. Would like a KPI on to show LodgeName, Selected Day, Anticipated Food Cost, Target
a. Same thing for a selected Month and year
b. The KPI will show red or green if the variance is off between Anticipated Food Cost vs Target
4. Be able to print a report