Feb 14, 2018
Crazy Table Gymnastics – Part 1 – Dynamic Column Categories
When I teach Power BI to new users, there are typically questions about how to get Power BI to act more like Pivot Tables in Excel. Through my discus...
Posts – Page 23
Page 23 of 25
Jan 31, 2018
Adding Data Types Within Query Editor
If you have spent any time working in Power BI, your very first step is to, wait for it… Get Data. Using Get Data will start loading your data into t...
Jan 19, 2018
New Layout – Splash o Red
First off, let me say WOW! The announcement of Layouts was well received by the Power BI Community. Thank you so much for the positive feedback. So...
Jan 16, 2018
Introducing Layouts
How do I get free Power BI layouts for my reports?
Jan 15, 2018
Move Visuals Between Reports
There are cases when working with Power BI files, that you would want to transfer a visual from one report to another report. While this feature is n...
Dec 29, 2017
Power BI Connections: Direct Query
Now that we've covered the basics of connection types, let's dive into Direct Query and when to use it for your Power BI reports.
Dec 20, 2017
Start of Month DAX Calendar
While on a recent project I needed to build a variation of the DAX date table with start-of-month dates. Here's how to create one.
Nov 24, 2017
Custom Usage Metrics Reporting
How do you build custom Power BI usage metrics reporting?
Nov 16, 2017
Power BI Connections: Import
Power BI’s default connection type is Import. In fact, if you have never dealt with a data source that handles multiple loading methods, you may never...
Nov 14, 2017
Fixing the Truncating Bar Chart
The more you work with Power BI Desktop it is more than likely you will find some tool limitations that impact your overall design pursuits. As I hav...
Nov 1, 2017
Creating A DAX Calendar
How do I create a date table with DAX in Power BI?
Oct 16, 2017
Power BI Connection Types
What is the difference between Import, DirectQuery, and Live Connection in Power BI?
Oct 12, 2017
Power BI World Tour 2017 – Chicago – Intro to DAX
DAX (Database Access Expressions) can be quite complex. It is essential to being able to appropriately manipulate the Power BI data model for the vis...
Oct 11, 2017
Power BI World Tour 2017 – Chicago – Top Tips
To everyone who was able to attend the Power BI World Tour 2017, Thank you! It has been a pleasure presenting my favorite tips and trips. This post...
Sep 8, 2017
Power BI September 2017 Release
September is here and there is a new update for Power BI desktop! I’m so excited for this month’s update as there are many solid features. One of th...
Aug 14, 2017
Best Practices for Sharing
I’ve been using Power BI since it was released back in 2015, and I’ve found that when talking with other PowerBI users there is always a little confus...
Aug 11, 2017
Power BI August 2017 Release
I love these updates, it’s like Christmas comes every month!! This month we get a ton of really great features, I for one am super pumped to get into...
Jul 25, 2017
Ranking Values with Measures
How do I rank categories with a DAX measure that updates when the slicer changes?
Jul 5, 2017
Use Multiple Connections Between Tables
For those of you who work in supply chain management this tutorial will be right up your alley. In my previous job position I had a lot of interactio...
Jul 3, 2017
UseRelationship DAX Tutorial – Curbal
Here is another great tutorial from Curbal. This tutorial teaches you how to use the DAX function UserRelationship. This is important when your deal...
Jun 13, 2017
Microsoft Data Insights Summit
This year I had the wonderful privilege to attend the Microsoft Data Insights summit for 2017 as a speaker. My topic was the Top Ten Tutorials from P...
Jun 10, 2017
Power BI June 2017 Release
This month we have a big release for Power BI Desktop and for the Power BI service. There are a number of great new features. For the everyday user...
May 5, 2017
Using Variables within DAX
How do I use CALCULATE and DAX variables to compare this year vs last year after a visual filter?
May 3, 2017
Power BI May 2017 Release
It’s that exciting time of month again. Time for another power BI desktop release. This month here are a couple of good highlights you should check...