Tag Archives: data visualizations

5 Tips for #PowerBI

After a couple months of fun with Power BI, I’ve picked up a few little tricks along the way that have helped me to be able to create some pretty cool data visualizations and dashboard reports. Here are five Power BI tips and tricks that you may find useful as you begin creating dashboards for your organization.

New to Power BI? Start here to get acquainted!

1) Use a pie chart or donut chart as a KPI

One of the ways we can create a KPI visualization is to use a pie or donut chart visualization, which you can see here.

image

In the chart above, I create a KPI to quickly display which tight ends score more than, less than or equal to the average number of touchdowns all tight ends scored last year allowing me to quickly identify tight ends that score more TDs than average.

Here is my calculated column to create the KPI value for you to have as an example:

TD KPI = if(int('TE Stats'[TD])>INT('TE Stats'[Avg TE TDs]),"1",IF(int('TE Stats'[TD])<int('TE Stats'[Avg TE TDs]),"-1","0"))

 

Then configure a pie chart as follows.

First, I place my KPI calculated column as the Legend and as the Values.

Power BI KPI pie chart

Then I hid all the labels and configured the colors to display red (-1), yellow(0) or green(1) depending on the value of the KPI.

Power BI KPI pie chart

Now when I use a slicer to select a player, my pie chart acts as a stoplight KPI. Cool!

Power BI KPI

2) Use a chart as a slicer

I’ve previously blogged this tip before, but this one is too nifty to not share again, in my humble opinion. One of the advantages to using a visualization like a funnel chart as a slicer is you gain the ability to single-select a filter, which is something the current slicer lacks. Check out this post to learn more about leveraging Power BI’s natural cross filtering to create some pretty cool slicers.

image

3) Create a spark line with a line chart

A nice way to create a small trend line, also called a spark line, is to use a line chart visualization which you can see below.

Power BI sparkline line chart

This trick is pretty easy. Just create a normal line chart visualization, hide all the labels and shrink the chart down to the desired size.

4) Use a scatter graph and matrix to create a calendar chart with day labels

Last week you may have seen my blog post on how to use a scatter graph to create a calendar chart. One of the ways you can improve the calendar scatter graph is to create the visualization along side a matrix visualization, as seen below.

image

You can use the matrix to display the names of the week below each day in the calendar and then also optionally display the totals by day.

5) Right align the y-axis on a bar chart to prevent the labels from hiding

The bar chart is a great visualization type to use in your Power BI dashboard because its so easy to differentiate the differences between the categories. But one of the problems with the visualization in Power BI is that sometimes its hard to see the categories on the y-axis if the chart is too small. See the image below to see an example the issue I’m talking about.

image

One way you can work around this is to right-align the y-axis. This will cause the full value of the y-axis categories to always be displayed in all their glory albeit on the right side.

image

You just have to live with the category labels on the right side of the bar chart.

Resources

Need more Power BI tips? Check out these tips:

Here’s three Power BI best practices to follow.

Here are the new visualization types in Power BI.

Converting Power Pivot models to Power BI is now a thing!

Power BI Tip: Use a Scatter Chart to Create a Calendar Report

Power BI Desktop Scatter Chart

The Scatter Chart in Power BI and Excel is very useful chart for visualizing three different metrics in tandem. But with a little bit of work you can use a Scatter Chart to create a Calendar chart for visualizing your metrics across the days of an individual month.

New to Power BI Desktop? Start here!

To configure a Scatter Chart too mimic a Calendar type report, you need the following: Continue reading Power BI Tip: Use a Scatter Chart to Create a Calendar Report