Building the Final Power BI Report

Step 1: Add a Date Filter

1. Open Power BI Report:

   Open your Power BI report where you've already loaded the data.

2. Create a Date Slicer:

   1. Go to the Report view.
   2. In the Visualizations pane, select the Slicer visual.
      
   3. Drag the Date field from the Fields pane to the Values section of the slicer.
   4. Adjust the slicer to show the date range you want to filter by, such as a calendar view or a range slider.
      

3. Configure the Slicer:

   1. Click on the slicer to activate the Format pane.
   2. Customize its appearance and interactions, such as enabling single select, changing orientation, or applying formatting.

Step 2: Add Charts

1. Create a Bar Chart:

   1. In the Visualizations pane, select the Stacked Bar Chart icon.
   2. Drag the VehicleID field to the Y-axis.
   3. Drag a relevant numerical field, like Working Time in Minute to the X-axis.
      
   1. Click on the chart to activate the Visualizations pane.
   2. Select the Filters section.
   3. Expand VehicleId to add the filter on the stacked bar graph.
   4. Set the filter type to Top N.
   5. Enter 5 as the number of items.
   6. Choose Working Time in Minute as the value by which to filter.
   

2. Create a Treemap as a Filter:

   1. Select the Treemap visual from the Visualizations pane.
      
   2. Drag the Vehicle Type field to the Category and Values field.
   3. Use the treemap to filter other visuals by clicking on the segments representing different vehicle types.
   4. Format the treemap using the Format pane to adjust the size, labels, and colors.

3. Create a Donut Chart:

   
   1. Select the Donut Chart icon from the Visualizations pane.
   2. Drag the Vehicle Name field to the Legend.
   3. Drag the Distance Travelled field to the Values.
   4. Use the Format pane to customize the donut chart’s appearance, such as adjusting the size, colors, and data labels.

4. Create a Line and Stacked Column Chart:

   
   1. Select the Line and Stacked Column Chart icon from the Visualizations pane.
   2. Drag the Vehicle Type field to the X-axis.
   3. Drag the Fuel Consumed field to the Column Y-axis.
   4. Drag the Working Time in Minute field to the Line Y-axis.
   5. By default, Power BI sums these values. To change this to an average:
   
   1. Click on the dropdown arrow next to the field name in the Values section.
   2. Select Average from the list of available options.
   6. Format the chart using the Format pane to customize colors, lines, and column appearances to match your report's theme.

5. Create a Line Chart:

   
   1. Select the Line Chart icon from the Visualizations pane.
   2. Drag the VehicleId field to the X-axis.
   3. Drag Duration in Minute and Moving Time in Minute fields to the Y-axis.
   4. Drag Idling Time in Minute and Parking Time in Minute fields to the Secondary Y-axis.
   5. Format the chart using the Format pane to adjust line styles, colors, and labels for better visualization and clarity.

Step 3: Add a Text Box and Cards

1. Add a Text Box for the Report Name:

   
   
   1. Select the Text Box icon from the Insert menu.
   2. Type in the desired report name, such as "Vehicle Analysis Report," and format the text using the options in the Format pane.
   3. Position the text box at the top of the report to serve as the title.

2. Add Cards for Vehicle Counts:

   
   1. Select the Card visual from the Visualizations pane.
   2. Drag the VehicleId field to the Fields section of the card.
   3. Change the aggregation from First to Count(Distinct) to display the total number of unique vehicles.
   4. Disable the category label in the Format pane and add a custom label, such as "All Vehicles Count."
      
      
   5. Repeat these steps to create additional cards for the Excavator Count and Dumper Count by applying filters to the card visuals to count only those specific types.
      

Step 4: Add a Table

1. Create a Table Visual:

   
   1. Select the Table visual from the Visualizations pane.
   2. Drag the following fields to the table: Vehicle Type, Ride Efficiency, Fuel Consumed, and Kms Travelled.
   3. Use the Format pane to adjust the table's style, such as font size, color, and gridlines, to enhance readability.

Step 5: Arrange and Finalize the Report

1. Rearrange Visuals on the Canvas:

   Drag and drop all visuals to organize them logically on the canvas. Ensure each element is clearly visible and contributes to the overall story of the report.

2. Style the Report:

   Use consistent color schemes and formatting options across all visuals to create a cohesive look. Adjust the size and position of visuals for a balanced layout.

3. Finalize and Review:

   

   Review the entire report for accuracy and interactivity. Make sure all filters, slicers, and cards function as expected. Add any additional notes or descriptions necessary for clarity.

Conclusion

By adding a text box for the report name, cards for vehicle counts, and a detailed table, your Power BI report becomes a comprehensive and interactive tool for analyzing vehicle data.