Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Power BI Pulse Charts


By:   |   Updated: 2018-03-15   |   Comments   |   Related: More > Power BI

Problem

What are Power BI Pulse Charts and how are they used? Can you provide a step by step example on how to get started with Power BI Pulse Charts?

Solution

One of the neat features of Power BI is the proliferation of various visualizations. Between the default visuals available upon install plus all the custom visualizations that have been created and available in the Microsoft store, the variety of visual solutions is ever growing. The pulse chart is one of those charts that excels at telling a story, a story with visual cues and animation.  Pulse charts act like a “moving” pulse monitor you may see in a hospital, so thus the name Pulse. As an added benefit, the pulse chart provides an auto-run option which automatically starts the animation for the chart. Furthermore, “highlighted” events can enhance the animation by creating a temporary pause to highlight a particular event or events.

Implementing a Pulse Chart in Power BI

Since the pulse chart is a custom visualization we first must import it into Power BI. It can be downloaded from the Microsoft app store at: https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381006?src=office&tab=Overview. Of course, you will want to download Power BI Desktop if you have not already done so: https://powerbi.microsoft.com/en-us/desktop/.

Puse Chart Dowload - Description: Pulse Chart Download

You will want to download the visual to your local machine.

Pulse Chart download to local - Description: Pulse Chart download to local

After starting Power BI Desktop, you will need to import the newly downloaded custom visual into the visualization gallery.

import custom visual - Description: import custom visual

As an alternative, the Pulse Chart visual can be imported directly using the Import from store option.

Power BI Store - Description: Power BI Store

Now we are ready to use the Pulse chart. Our first step is to import some time series data into Power BI. I am using a data set which shows attendance figures from Major League Soccer (MLS) matches. This type of data is perfect as it shows a data measure over a time series. For this exercise, we will show the maximum attendance per day (to emphasize when record attendance was achieved).

get data

Next, we will load the attendance data into the data model.

pulse chart

The Att (attendance) field will be used as the main measure while the Date field will be used for the x-axis.  We will also add an event field to the data set which we will employ later to highlight special records in MLS history. More to come on that item. To get back to the design window from the data model, you would want to select to Close & Apply.

Now that we have a prepared dataset, the Pulse Chart is now ready to be setup. We have several items that will need to be added to the chart. The first step in setting up the Pulse chart is to select the chart from the chart gallery and drag it onto the design grid.

select chart - Description: select chart

Next, we begin to add the data items.

add data to chart - Description: add data to chart

For the Timestamp field, we will add the MLS match Date field. The TimeStamp field is really the x axis for the chart. Next, the Att / Attendance field is added to the Values area; this figure is the total attendance per match. Since we want to show the highest attendance event per day, the maximum attendance value for matches on that day is used. This value becomes the y value for the chart.

additional items added - Description: additional items added.

We next add the Special field to the Event field. The Event field shows the value to the Event field and the Att / attendance value to the Event Size field. This item is one of the neat features of a Pulse Chart. The event field is used to highlight a particular special item at a particular time; the event size will emphasize the attendance value at the event occurrence on the chart.

One last item that was added to the Pulse Chart is a filter; we will limit the chart to just 3/5/2013 to 03/04/2018.

So on an initial pass, we have the following result for our chart. As you can tell, it does need some work to get the formatting and aesthetics in a better format.

Chart v1 - Description: Chart v1

Our first formatting steps are to adjust the color of series, changing it to red and then turning the gap property off. Turning off the gap property allows the graph to flow and be connected between one year of matches and the next.

formatting  series - Description: formatting series and gap.

Now the Popup formatting is set; this particular set of properties sets the formatting of the Popup areas. This Popup will display the details from the event setting; in our example that would be the “Special” field. These properties control the look of the popup box (sort of like a tool tip) and include items like the font size and color, the background color and the size of the overall popup box.

format popup - Description: format popup

The next set of options controls the size of the circle that show when an Event takes place.

format dots - Description: format dots

The X and Y axis properties control the coloring and location of the x and y axis on the chart.  You may have noticed on the original chart, the x axis was centered horizontally. Based on the number values to chart, moving it to the bottom of the chart was a better option.

format x and y axis - Description: format x and y asix

The subsequent option to be set is the playback properties; this list of properties controls how fast the “pulse” line will play across the screen and whether the playback occurs automatically or not. Furthermore, the pause option tells Power BI how long to stop and display the popup when an event occurs. Finally, the button color controls the color of the play, pause, forward and backward buttons which appear in the upper left corner of pulse chart grid.

playback option - Description: playback option

The Title and Background formatting options are self-explanatory, and control how the tiles appear on the chart and whether a background color should be used to enhance the visual.

format title - Description: format title

The last 3 options control: 1) the lock aspect of the chart for sizing purposes, 2) the border color and 3) the general location and size of the chart.

set lock aspect - Description: set lock aspect

So now that we have completed our formatting for the chart, we are ready to “play it” by clicking the play button. The chart starts at the left side and begins drawing the red line. When the chart gets to an “event”, the playback pauses, and the popup box is displayed as illustrated in the first screen print below. The chart pauses for the time frame we specified above, and then begins drawing again. When the drawing gets to the next event, as shown in the second screen print, the next event is displayed in the popup.

play 1 - Description: play 1

drawing 2 - Description: drawing 2

This process continues until the chart drawing reaches the end data for the data set. If set in the playback options, the chart will automatically replay the drawing again from the left side.

maximum attendance

Furthermore, each dot can be clicked on to display the event appearing at that point in time.

select an event - Description: select an event

Once you are satisfied with your new chart, you would need to publish this report to the PowerBi.com online service to display for others.

In this tip, we covered using the new Pulse Chart visualization available in the Microsoft Power BI gallery.

Next Steps


Last Updated: 2018-03-15


get scripts

next tip button



About the author
MSSQLTips author Scott Murray Scott Murray has a passion for crafting BI Solutions with SharePoint, SSAS, OLAP and SSRS.

View all my tips




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools