Jan 14, 2020
KPIs in Power BI
KPIs are a key visualization type used to convey high level metrics to the end users. They provide an at-a-glance metric that allows business users to...
Posts – Page 20
Page 20 of 25
Dec 23, 2019
Introducing Scrims
PowerBI.tips is excited to announce our new tool to help you build the best looking reports, Scrims. We’ve...
Dec 21, 2019
Scrims Instructions
Thanks for your interest in our product Scrims. For more details on what is a scrim click this link to Learn More. **Download** a scrim from the prod...
Dec 6, 2019
More Visuals Mo Problems
In some recent conversations the notion of minimizing the number of required visuals came up as a topic. While I know from talking with the Microsoft...
Nov 27, 2019
Embedding Paginated Reports
Over the course of time Power BI has come to encompass a wide variety of technologies and tools. One such product that has been integrated into the su...
Nov 20, 2019
Scale a Visual
For each visual in Power BI Desktop there is a button called Focus Mode. This feature highlights a single visual. While this can be helpful, it does r...
Nov 12, 2019
Consolidate Report Pages Easily with Visual Grouping
We do a ton of Layouts here at powerbi.tips and with the introduction of the new visual grouping feature I wa...
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...
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
Power BI requires a gateway for refreshing on premises data sources. There are a myriad of different data sources that you can create and two differen...
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
This post will walk through how to pull daily stock price from Yahoo! Finance, then transform the data using a technique called a query branch. It wil...
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
As report authors we sometimes get caught up in how easy it is to create a report and provide value to the business. Each report is an opportunity to...
Sep 30, 2019
Custom Sort Order Within a DAX Measure
This post will answer how to sort a measure that returns text values to a custom order, without affecting other columns. It will utilize the DAX funct...
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
There are different ways you can connect to a multitude of different data sources. I’ve written about the different connection types before and you ca...
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
Sometimes, we want the users to see different metrics, but do not want to take up too much space on our page. The scenario we are going to walk throug...
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...