Power BI Hotel Booking Occupancy Visual Report Bar and Column Chart, Gauge

 

From Calendar Matrix Visual to a multitude of charts.

Same data, different presentation.

I have not added any new bookings, so our hotel does not perform well.

I thought I will show in this video more of data modelling and logic of visuals, rather than data entry and its effect on visual.

I have added few measures for % calculation. The famous CALCULATE() formula.

Booked days = Calculate(COUNTROWS(biRoomCalendar),Filter(biRoomCalendar,[Current Status]="B"))

Booked, % = Calculate(COUNTROWS(biRoomCalendar),Filter(biRoomCalendar,[Current Status]="B"))/COUNTROWS(biRoomCalendar)

Empty,% = Calculate(COUNTROWS(biRoomCalendar),Filter(biRoomCalendar,[Current Status]="A"||[Current Status]="V"))/COUNTROWS(biRoomCalendar)

M&OO,% = Calculate(COUNTROWS(biRoomCalendar),Filter(biRoomCalendar,[Current Status]="O"||[Current Status]="M"))/COUNTROWS(biRoomCalendar)

I did update conditional formatting of font to "hide" letters.

Thanks for reading :)

If you wish to say thank you please donate to the charity I use to work for.

Donate here