Dec 5, 2016
Measures – Year Over Year Percent Change
This tutorial is a variation on the month to month percent change tutorial. Th...
Posts – Page 23
Page 23 of 24
Nov 16, 2016
Grouping and Improved Date Slicer
In the October update of PowerBI Desktop we were given a number of really useful features, ranging from a new Date Slicer, Grid lines, Grouping, Binni...
Oct 17, 2016
Pareto Charting in PowerBI
Build a Pareto chart in Power BI using DAX measures for cumulative totals and percentages. Identify which products comprise the majority of your sales.
Oct 10, 2016
Map with Data Labels in R
Create a US map in Power BI with state labels and year-over-year change indicators using R and ggplot2. Color-coded labels show positive and negative trends.
Oct 4, 2016
Fixing Measure Madness
Organize your Power BI data model by creating a dedicated measures table. Group all your DAX measures in one place for cleaner, more maintainable reports.
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.
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.