Jun 20, 2018
Segmented Filtering with Slicers
This weeks tutorial focuses on the need to control groups of visuals independently. This recently came up in a project where I needed to adjust all t...
Posts – Page 22
Page 22 of 25
Jun 6, 2018
Data Table Filters
Hands down best feature this year to date, Data Table Filtering! In the June 2018 Power BI Desktop Microsoft released the ability for you to navigate...
May 17, 2018
Apply a Filter to a Slicer
Often when working with a Power BI report you will add a slicer that has a “Blank” item in the selection criteria. From a usability standpoint you mi...
Apr 23, 2018
When to Use Publish to Web
There are often questions surrounding Publish to Web. What is it? How can I use it to share my reports? This video walks through the proper usage f...
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.
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...