Apr 18, 2018
Introducing Lingo
Update: This tool has been deprecated as of 2024-11-27. You can now find this as a downloadable HTML file on GitHub.
Posts – Page 21
Page 21 of 23
Feb 26, 2018
Power BI Connections: Live Connection
Of all the connection types, I’ve always gravitated towards this one. I imagine it is because I come from the database developer side of things. I’m a...
Feb 21, 2018
Crazy Table Gymnastics – Part 2 – Build Support Materials
This is part 2 in the 3 part series on developing super cool tables using some fancy measures. In part 1 we walked through how to build a table that...
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...
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
PowerBI.tips is extremely happy to be part of, and contribute to, the Power BI Community. We’re constantly trying to think of new and interesting ways...
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
One of the really cool features contained within the PowerBI.com service is the ability to monitor how often your dashboard or report is being viewed....
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
There are many cases when you will need to create a date table within Power BI desktop. This could be as simple as creating a master date table or mo...
Oct 16, 2017
Power BI Connection Types
Get Data – Power BI Connection Types: An Introduction to understanding Import, Direct Query, and Live connections.
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
In many reports we produce we often need a method to score or rank data. For example, we may need to list the sales totals for the sales team and ran...
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...