1. Mouse actions and Unicode
Hi again; I'm hoping you're enjoying the course so far. In this demo, we are going to focus on the Overview page. First, let's format the buttons by using the style dropdown, starting with the inspection report button. Let's change the icon on the Disabled state to a blank shape.
I will also change the button text to read "Select an Inspection Report" when the button is disabled.
I will add a border to the button to make my bookmark stand out. But let's do this only when hovering over the button. To do this, set the border weight to 0px in the default state.
Then, for the On hover state, we'll set the border weight to 3. Now, when we hover over the button, we get a solid border.
We will also have two pages act as tooltips. The page I will create is called Inspections over Time. I will hide it by right-clicking the page and choosing "Hide Page." That way, it will not show up when users view the report in Power BI Online.
I want to make this a tooltip. To do that, I need to do two things in the Format menu. First, I need to set the Tooltip slider to On in the Page information menu. Then, I need to change the Type of page in the Page size menu to "Tooltip."
I now have a small area to work with and will add a line chart with the Date in the axis and number of inspections as the value. Let's expand down one level to show data by quarter.
The other page is called Summary of Issues. It shows the category and number of violations in a table.
Now let's use these. Back on the Overview page, I'll select the table. In the Format visual menu, I'll enable Tooltip. Then, we want the report page to be "Summary of Issues."
Now, if I mouse over an inspection, I can see a table with the specific issues found during that inspection.
Next, we'll add a visual header tooltip. To do this, we need to go to the Header Icons menu and expand the Icons dropdown. Next, we'll need to toggle "Help tooltip" to on. Once we've enabled this, a new option called Header Tooltip will be enabled below. Now we can set the report page "Inspections over Time" as the tooltip. Now, if I hover over the question mark icon at the top of the table, I can see our Inspections over Time graph.
We can use Unicode icons, emoji, and formatting to pack more information into our table. Let's start by adding a new column on the Restaurants in Wake County table called "Facility Type Display" with the following code.
This displays an icon for each facility type. We'll use a salt shaker for restaurants, a truck for food trucks, a school for school lunchrooms, and so on. Add this new column to the table and rename it to "Type" to see it in action.
Let's remove the number of inspections and add the number of violations and score instead. Now we can use conditional formatting to make the table more visually appealing. We'll make the number of violations a data bar by selecting the collapsible menu indicator for Number of Violations and choose "Data bars" from the Conditional formatting menu.
I'll show just the bar and then select OK.
Then I'll rename the column to Violations.
For the score, I want to show icons by value.
I'll select increasing bars but need to change the default values to match the fact that restaurant scores rarely go below 90 percent.
Now we can see much more information about the inspection from our overview chart.
The last step is to review interactions. Select "Edit interactions" in the Format menu, and you can control how table selections affect other visuals on the page.
For the bar chart, we can either filter results or highlight them. By default, we highlight. But for this chart, it makes more sense to filter.
Select "Edit interactions" again to close interactions. We've done a lot with the user interface. Now it's your turn to give it a try!
2. Let's practice!