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.