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.
Posts – Page 25
Page 25 of 25
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
How do I load Excel files from SharePoint into Power BI Desktop?
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
How do I load many Excel files from a folder in Power 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
How do I calculate month-to-month percent change in DAX?
Jun 16, 2016
Loading Data From Folder
How do I load only the newest file from a folder in Power Query?
Jun 10, 2016
Measures – Dynamic Percent Change – Using DAX
How do I calculate percent change between the minimum and maximum year selected in DAX?
May 27, 2016
Measures – Dynamic CAGR Calculation in DAX
How do I calculate dynamic CAGR in DAX?
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
How do I calculate a total with a DAX measure that changes when I select data on the page?
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
How do I fix a Power BI Desktop query when its Excel source file has moved?
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.