Oct 3, 2016
Intro to Guy In a Cube
Discover Guy In a Cube, one of the best Power BI video content creators. Adam Saxton from Microsoft delivers short, packed tutorials that are incredibly helpful.
Posts – Page 24
Page 24 of 25
Sep 30, 2016
Using Advanced Mapping in ArcGIS Preview
Explore the ArcGIS Maps visual in Power BI with heat maps, reference layers, and advanced selection tools. Add demographic overlays like household income.
Sep 27, 2016
HexBin Plot using R
Create beautiful hexagonal bin plots in Power BI using R and ggplot2. Visualize data density with heat map style honeycomb patterns.
Sep 21, 2016
Digging Deeper with R Visuals for PowerBI
Create advanced R visuals in Power BI combining area plots, bar charts, and scatter points using ggplot2. Learn how R scripts respond to slicer selections.
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.
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.