📊
Public Data Visualization Guide
  • Data visualization standards for SF.gov
  • Why do this?
    • Now you try!
  • Thoughtful design
  • Accessibility
    • Some basics
    • Color
    • Formatting Data Visualizations
    • Formatting tables
    • Alt Text
  • Mobile view
  • More resources
  • Analyst checklist
  • Using the Power BI template: A step-by-step guide
  • Data management
  • Webpage content for data pages
  • Publishing Power BI dashboards to SF.gov
  • Resources and links
  • Gallery of dashboard transformations
Powered by GitBook
On this page
  • Step 1: Set up
  • Step 2: Visualize data
  • Step 3: Accessibility updates
  • Step 4: Mobile view
  • Step 5: Clean up and check your work
  • Converting a pre-existing file to the template

Was this helpful?

Export as PDF

Using the Power BI template: A step-by-step guide

A quick and simple 5-step guide to using our Power BI template.

PreviousAnalyst checklistNextData management

Last updated 2 years ago

Was this helpful?

Use the following steps to easily leverage our template and create your own dashboards.

Click here to download the template. You will need to update to at least the July 2021 version of Power BI to open the template. If you have an older version, contact your IT to install the latest version of Power BI.

Step 1: Set up

  • For this illustration, we create a chart of film locations over time

    • Dataset: https://data.sfgov.org/Culture-and-Recreation/Film-Locations-in-San-Francisco/yitu-d5am

  • Download the template

  • Save template with new file name, so you can refer back to original template

  • Import data and connect to date table

    • Assume that all of the underlying data in a public Power BI dashboard is completely accessible to the public. Before making a public dashboard, you'll need to consider data security.

    • After import, you may need to convert your date/time field to date format

  • Identify the format you want to use

  • Drop pages you will not be using

Step 2: Visualize data

  • Replace values in chart(s)

  • Replace values in table(s)

    • Remember: you must have a table of data, and preferably a text equivalent of the data viz

  • Update titles

  • Turn off interactions

  • Review formatting guidance

Step 3: Accessibility updates

  • Update all alt text

    • Use example language in the template

  • Verify tab order

Step 4: Mobile view

  • Duplicate tab

  • Resize visuals and re-size page

  • Order visuals in tab order, confirm filters appear before the visuals that they filter

  • Mobile formatting updates

    • Shorter table

    • If you are using toggles, reformat to show all data without toggles on mobile view

Step 5: Clean up and check your work

  • Remove spacers

  • Delete all mock data tables, apply changes, and verify nothing is broken.

  • Name tabs desktop and mobile

  • Complete developer checklist

    • Verify Alt text (click every visual/textbox -> format -> expand general -> inspect alt text)

    • Verify tab order is correct (click outside dashboard and use tab key)

  • Publish to Power BI Online

  • Use screen reader to verify alt text

  • Publish to web

    • If you do not have the publish to web permissions, read DataSF's Power BI Publish to Web Tip Sheet and then contact your IT and supervisor for permissions.

Converting a pre-existing file to the template

If you have a pre-existing Power BI dashboard you'd like to convert to this template, you have options. You can build within the template. In that case, you will just have to re-create your data model within this file. The easiest way to do this is to copy and paste each query code from the advanced editor and recreate your measures. Then just follow the same steps above.

If your pre-existing file is very complex, you can convert a file to this template using the steps below.

  • Open pre-existing dashboard

  • Apply template JSON style (the json file in this folder)

  • Add new tab

  • Re-size new blank page to width = 700, height = 800

  • Copy/paste visuals from template file. Or, add new visuals

    • DO NOT copy or use any of the pre-existing visuals

  • Complete all design and accessibility steps above

  • Complete checklist