Tutorials Archives - Page 6 of 8 -

Using Parameters to Enable Sharing

2017-03-21 Mike Carlo

This week I had a number of team members tell me how difficult it was to share a PBIX file and the corresponding data between team members. The department hasn’t committed 100% to the idea of […]

Import Color Theme & Color Theme Generator

2017-03-06 Mike Carlo

March is an exciting month, and with this release of Power BI we have been given some long asked for features. One such feature is the ability to import a color theme. The color theme […]

Get Your OData Here

2017-02-21 Mike Carlo

For those of you who are following my tutorials, you are most likely to understand that each tutorial comes with it’s own data source. This has been intentional so we can both walk through the […]

Power BI has been an continually evolving tool over the last year. The Matrix visual is powerful and mimics much of the functionality of a Pivot Table within Excel. I will admit, the Matrix visual […]

Measures – Year Over Year Percent Change

2016-12-05 Mike Carlo

This tutorial is a variation on the month to month percent change tutorial. This specific exploration in year over year performance was born out of reviewing my google analytics information. The specific analysis question I […]

Grouping and Improved Date Slicer

2016-11-16 Mike Carlo

In the October update of PowerBI Desktop we were given a number of really useful features, ranging from a new Date Slicer, Grid lines, Grouping, Binning, Top N Filters, and R-powered custom visuals. For the […]

Pareto Charting in PowerBI

2016-10-17 Mike Carlo

The Pareto chart is a handy visual, but is not so easy to build in either excel or PowerBI. In a Pareto chart, information is provided about an individual product or category as a bar, and […]

Fixing Measure Madness

2016-10-04 Mike Carlo

Often times when you’re working with large data models you will have multiple tables with many relationships. It could be complex maybe you’ve seen something like the following: Once all the tables have been loaded […]

Using Advanced Mapping in ArcGIS Preview

2016-09-30 Mike Carlo

In the September 2016 release of PowerBI, Microsoft introduced a new visual called the ArcGIS Maps preview. For more information on the maps integration you can read the following post from Microsoft. This tutorial will […]

HexBin Plot using R

2016-09-27 Mike Carlo

Continuing on the theme with R this month, this week tutorial will be to design a hexagonal bin plot. At first you may say what in the world is a hexagonal bin plot. I’m glad […]