Exercise - Add a logo to the manufacturer filter

Completed

In this unit, we continue adding more functionality and visual elements to help wrap up our report. Ensure that you're working on the MyFirstPowerBIModel file that you have been using in the previous units.

Now it would be nice to add logos of the manufacturer to the Slicer instead of just text. Let's do it.

  1. Check that the Manufacturer slicer visual is still selected. From the Data pane, select the Logo field from the Manufacturer table. (Do not select the checkbox; only select the name of the field.)

  2. From the ribbon, select the Column tools tab and choose the Data Category drop down.

  3. Then, select Image URL. Setting the data category property to Image URL helps Power BI understand that the data in this field is a URL so it can render the image in the report.

    Screenshot highlights the selection of the Logo field from the Manufacturer table, and the selection of the Image URL option for the Data category.

  4. With the Slicer visual selected, drag and drop the Logo field from the Manufacturer table to below the Manufacturer column in the Field box in the Visualizations pane.

  5. Select the X to the right of the Manufacturer field in the box so that the Logo field replaces it.

    Screenshot highlights the addition of the Logo field from the Manufacturer table to the Field for the slicer visual.

  6. Resize and move the visuals as needed.

  7. Select the VanArsdel, Ltd. logo in the Manufacturer slicer visual to filter all the other visuals.

  8. Select the Sum of Revenue by Year visual.

  9. From the Visualizations pane, select the Line and clustered column chart to change the visual type.

  10. From the Data pane, drag and drop the % Growth field from the Sales table to the Line y-axis box.

    Screenshot highlights the selection of the line and clustered column chart visual type, and the addition of the % Growth field within the Line Y-axis field.

    This provides a representation of the revenue and growth over time.

Section 2: Gauge visual

Now, let's select the Sum of Revenue card visual so we can change it to a Gauge visual.

  1. Select the Sum of Revenue card visual, and from the Visualizations pane, select the Gauge visual.

  2. From the Data pane, drag and drop the PY Sales field from the Sales table to the Target value in the Visualizations pane.

    Screenshot highlights the selection of the Gauge visual type and the addition of the PY Sales field within the Target Value field.

  3. Resize and move the visuals as needed. Now we can compare Revenue with the target.

    Next we'll select the colors for this visual.

  4. Select the Gauge visual.

  5. From the Visualizations pane, select the Format visual tab (the paint brush icon).

  6. Expand the Colors section.

  7. Select the drop-down for Fill color.

    Notice you can pick a color from the default color palette or pick More colors. No need to make a change here because the next steps will standardize all the report colors used.

    Screenshot highlights the location of the Fill color drop down for the Gauge visual under the Format visual tab of the Visualizations pane.

    Let's check out some of the themes available.

  8. Ensure that the Gauge visual is still selected.

  9. From the ribbon, select the View tab and choose the drop-down arrow within the Themes menu.

  10. Then, select the Temperature theme.

    Screenshot displays the various available themes.

Notice that the colors on all the visuals are updated. Feel free to try the other out-of-the-box themes.

Now that we covered adding logos to the manufacturer slicer, changed the clustered column chart, adapted the card visual to a gauge, and looked through report themes, in the next unit we'll cover the application of custom report themes.