Sep 15, 2016
Using R Visuals in Power BI
Get started with R visuals in Power BI Desktop. Install Microsoft R Open, configure Power BI, and create your first correlation plot using the corrplot package.
Posts – Page 23
Page 23 of 23
Sep 1, 2016
Loading Excel Files from SharePoint
Learn how to connect Power BI Desktop to SharePoint document libraries and load Excel files. Enable scheduled data refreshes with SharePoint O365.
Aug 31, 2016
Building Date Table from Scratch
Create a custom dynamic date table in Power BI Query Editor using M language. Build week-based selectors that automatically update when refreshed.
Aug 30, 2016
Make Calendars Using DAX – Curbal
Learn how to create custom calendars in Power BI using DAX with Calendar() and CalendarAuto() functions. Video tutorial from Ruth Pozuelo at Curbal.
Aug 10, 2016
Load Multiple Excel (xls or xlsx) Files
Learn how to load multiple Excel files from a folder into Power BI using a custom function. Combine workbooks with multiple sheets into a single query.
Aug 4, 2016
Using Variables for File Locations
Learn how to create a variable query in Power BI to manage file locations. When you move files, update one query instead of changing every source path.
Jul 28, 2016
Measures – Intelligent Card Visual – Using DAX
Create a smart card visual in Power BI that displays the selected item name when one item is chosen, or shows the count when multiple items are selected.
Jul 14, 2016
Measures – Month to Month Percent Change
Learn how to calculate month-to-month percent change in Power BI using DAX. Use PREVIOUSMONTH to compare current month sales against prior month values.
Jun 16, 2016
Loading Data From Folder
Learn how to automatically load only the most recent file from a folder in Power BI. Perfect for automated reports that receive daily data files.
Jun 10, 2016
Measures – Dynamic Percent Change – Using DAX
Build a DAX measure that dynamically calculates percent change as you select different items in Power BI visuals. Learn to use DIVIDE and FILTER functions.
May 27, 2016
Measures – Dynamic CAGR Calculation in DAX
Learn how to calculate a dynamic Compound Annual Growth Rate (CAGR) in Power BI using DAX. The calculation updates automatically as you select different data points.
May 19, 2016
Query Editor – Editing M Code
Learn how to copy and paste queries to and from the Query Editor using the Advanced Editor. Master the M language to share and model your Power BI data.
May 7, 2016
Measures – Calculating a Sum
Learn how to create measures in Power BI to calculate totals using the SUM function in DAX. Watch how totals dynamically change as you select different data points.
May 2, 2016
Measures – Calculating % Change
Learn how to create percent change calculations in Power BI using DAX measures with practical examples using real-world automotive production data.
Apr 27, 2016
Power BI Histogram with Bins – Includes DAX
Learn how to create histograms with custom bins in Power BI using DAX measures to categorize and visualize your data distributions.
Apr 20, 2016
From Wikipedia to a Colorful Map
Learn how to pull data directly from Wikipedia into Power BI and create a beautiful filled map showing US population growth by state.
Apr 14, 2016
Map it, Map it Real Good
Learn how to create impressive map visualizations in Power BI Desktop using latitude and longitude data with this step-by-step mapping tutorial.
Apr 13, 2016
Manually Enter Data
Learn how to manually enter data directly into Power BI Desktop to create small tables for your visualizations without needing external files.
Apr 11, 2016
Query Settings – Fixing a Missing File
Learn how to troubleshoot and fix broken file connections in Power BI Desktop when your data source has moved or can't be found.
Apr 7, 2016
Folder of Files Loaded to Power BI Desktop
Learn how to load multiple files from a folder into Power BI Desktop using the powerful automated data loading feature that will change how you work with data.
Apr 1, 2016
Import CSV file to Power BI
Learn how to import CSV files into Power BI Desktop, create tables and charts, and copy visuals to build compelling data visualizations.
Mar 29, 2016
Import an Excel file into PowerBI
Learn how to load data from Excel into Power BI Desktop with this simple step-by-step tutorial covering the Get Data function and basic visualizations.
Mar 26, 2016
Welcome to my Site
Welcome to PowerBI.tips, a blog dedicated to learning and developing visualizations for Power BI Desktop, PowerBI.com, and data modeling in Excel.