Nov 9, 2019
Average Household Income Function in Power Query
This post will walk through how to pull an estimated household income from a US address. It will be completed all in the Power Query Editor. We will c...
Posts – Page 21
Page 21 of 25
Nov 5, 2019
Stacked Bar Chart
For this week we are building a stacked bar chart on https://Charts.PowerBI.Tips. While you can build this type of char...
Oct 30, 2019
Act like the business, Think like I.T.
This month at our Power BI User group in Milwaukee Seth and myself walk through some of the basics of Power BI. We digest how can we leverage Power BI...
Oct 29, 2019
Building a Gateway Cluster
How do I build a Power BI gateway cluster?
Oct 23, 2019
Make PBIDS Files
In October of 2019 Power BI released a new file type, PBIDS. The Power BI Desktop Source (PBIDS) file is a JSON object file that aids users connecting...
Oct 22, 2019
Historical Stock Price Function in Power Query
How do you get historical stock prices in Power Query?
Oct 15, 2019
Power Query – Get Started!
As a user that builds Power BI reports, did you know the different technologies that come into play when you interact with the tool? This is one of th...
Oct 8, 2019
Filled Donut Chart, Yumm..
We are starting today off with a fun chart. We will be making a filled donut chart. Typically, I don’t use donut charts but in this case I think we ha...
Oct 2, 2019
Power BI datasets: A Method to the Madness
How should you organize Power BI datasets for report authors?
Sep 30, 2019
Custom Sort Order Within a DAX Measure
How do I set a custom sort order inside a DAX measure?
Sep 26, 2019
Grouping with Style
# Grouping with Style The release of grouping visuals was an extremely welcomed feature. As one who builds lots of reports grouping elements together...
Sep 17, 2019
Updating PBIX Files in SharePoint: Do’s & Don’ts
I recently encountered a really frustrating experience related to a set of reports seeming to not update after some data source changes. I’d done this...
Sep 11, 2019
Dual Y-Axis Line Chart
Ever need two different scales on the Y-Axis of a line chart? If so, then this tutorial is for you. Learn how to create a dual y-axis line chart.
Sep 3, 2019
Power BI Refresh Overview
How does Power BI data refresh work?
Aug 30, 2019
New Layout – One
This layout continues to deliver fantastic visual guides to make your reports look top notch. This layout utilizes buttons for navigation without lock...
Aug 8, 2019
Dynamic Visuals using Buttons
How do I use buttons to switch one chart between Volume, Dollars, and Margin?
Jul 18, 2019
Icons upon Icons
I am just bursting with excitement!! This month the amazing Power BI team has yet again come out with a great new feature, Icon sets. In addition to t...
Jul 11, 2019
The Dynamic Time Matrix
Time and time again when I begin talking with Excel users and ask to see what current reports they are using, they usually show me a table with a mixe...
Jul 3, 2019
Quick Access Toolbar for the Win
I’m a lazy engineer. Let me qualify my statement. In lazy I mean I like to find the path of least resistance, the shortest distance between two poin...
Jun 20, 2019
2019 Microsoft Business Application Summit Retrospective
This year the Microsoft Business Application Summit (MBAS) was held in Atlanta Georgia. Despite some travel snafu’s (3 rebooking’s and 9 delays), we m...
Jun 20, 2019
Make Custom Visuals with no Code
Welcome to another installment of building custom visuals with the Charts tool from PowerBI.Tips.
May 1, 2019
New Layout – Square One
“Square One” utilizes the color theme as a background component that adds a pop of accent color only. This gives you the end user the maximum flexibil...
Mar 21, 2019
New Layout - Smooth Operator
Hey everyone! We're excited to release our latest layout 'Smooth Operator'. Download it now and give your reports a fresh look.
Feb 12, 2019
Make Custom Visuals – Create a Bar Chart
With the release of the custom visuals building tool Charts.PowerBI.Tips we received a number of comments requesting tu...