Exercise - Add a logo to the manufacturer filter
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.
Section 1: Add a logo
Now it would be nice to add logos of the manufacturer to the Slicer instead of just text. Let's do it.
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.)
From the ribbon, select the Column tools tab and choose the Data Category drop down.
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.
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.
Select the X to the right of the Manufacturer field in the box so that the Logo field replaces it.
Resize and move the visuals as needed.
Select the VanArsdel, Ltd. logo in the Manufacturer slicer visual to filter all the other visuals.
Select the Sum of Revenue by Year visual.
From the Visualizations pane, select the Line and clustered column chart to change the visual type.
From the Data pane, drag and drop the % Growth field from the Sales table to the Line y-axis box.
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.
Select the Sum of Revenue card visual, and from the Visualizations pane, select the Gauge visual.
From the Data pane, drag and drop the PY Sales field from the Sales table to the Target value in the Visualizations pane.
Resize and move the visuals as needed. Now we can compare Revenue with the target.
Next we'll select the colors for this visual.
Select the Gauge visual.
From the Visualizations pane, select the Format visual tab (the paint brush icon).
Expand the Colors section.
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.
Let's check out some of the themes available.
Ensure that the Gauge visual is still selected.
From the ribbon, select the View tab and choose the drop-down arrow within the Themes menu.
Then, select the Temperature theme.
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.