Excel Online to PowerBI Dashboard KPI - Must complete is 1 day
Budget: $10 – $15 CAD
Dashboard Requirements:
1. Would like PowerBI to have a dropdown list to be able to select a Lodge name for the day and see all the Blue column data from the excel file in a list or graph of some sort
2. Same as number one but select a Lodge Name, Month, and Year
3. Would like a KPI on to show LodgeName, Selected Day, Anticipated Food Cost( Target is $19.50), Anticipated Labour Cost per MDF (Target less than $34.25), for a selected Month and year upon the selection of the Lodge Name
a. The KPI will show red or green if the variance is off or on depending on the targets.
1. Would like PowerBI to have a dropdown list to be able to select a Lodge name for the day and see all the Blue column data from the excel file in a list or graph of some sort
2. Same as number one but select a Lodge Name, Month, and Year
3. Would like a KPI on to show LodgeName, Selected Day, Anticipated Food Cost( Target is $19.50), Anticipated Labour Cost per MDF (Target less than $34.25), for a selected Month and year upon the selection of the Lodge Name
a. The KPI will show red or green if the variance is off or on depending on the targets.
Related categories:
Power BI