PowerBI Visual Designs

This covers material from the following Microsoft Learn modules:

Note that we do not cover all of these features in detail. Focus on the items shown below.

Vis designs

Create the following charts

Create the following non-chart data displays:

For each, be able to set the title and axis label.

Report design suggestions

Tips:

  • Design from top/down and left/right
  • Add space around report elements
    • Set report size (page size custom)
  • Theme to use consistent colors
  • Time series
    • Show from left/right

Elements:

  • Text box (apply font, hyperlinks)
  • Buttons (back, open URL, bookmark)
    • Back
    • Bookmark
    • Drill through action
    • Page navigation
    • Format (hover, tool-tip)
  • Shapes (arrows, hearts, etc…)
  • Images (add)

Conditional formatting

See Microsoft tutorial

  • Right-click on a field in a table or matrix
  • Select conditional formatting
    • Pick style, such as background or font
    • Pick a scale

Spark-line

  • Right-click on a field
  • Pick ‘add a spark-line’

Bookmark

A bookmark is used to save the state of a page. Define a bookmark, and then assign buttons to switch between different bookmarks.

Process for switching between page states:

  • Create your data displays
  • Go to view and turn on both “Bookmarks” and “Selection”
  • Repeat for each view of your data:
    • Hide/show charts
    • Create a bookmark
  • Create a button and assign it to activate the correct bookmark
    • Note that the text of the button is under Format / Style / Text
    • Control-click to activate the button

Process for going to another page

You can also use bookmarks to navigate between pages.

  • Create your pages
  • Add a blank button
  • Go to the button action, pick Page Navigation, and select the correct destination page.

Custom Tooltip

You can create a custom tooltip page.

Microsoft Tutorial

Process:

Mobile report

Create a custom view for mobile devices