November release of Power BI Desktop delivered a highly requested feature – ability to configure interaction between visual elements in a report. Here is a quick tutorial of the configuration options. I have a report with 4 visual elements, a card, a clustered column chart, a bar chart and a donut chart. By default, when … Continue reading Power BI Desktop: Interaction between Visuals
Author: nikilprabhakar
POWER BI TUTORIAL : Using Variables in DAX
Earlier this year, new version of DAX was released. One of the key features with this release is the support for variables. Variables makes writing DAX code easier. Variables also make code easier to read and understand. Download sample data here. Data represents sales for a particular store. Products are categorized by seasonality and color. … Continue reading POWER BI TUTORIAL : Using Variables in DAX
POWER BI TUTORIAL: SURFACING POWER BI DASHBOARD IN POWERPOINT
Power BI Tiles add-in provides the capability to add interactive Power BI Tiles to PowerPoint. Let's see how to do it Open PowerPoint From the ribbon select Insert -> My Add-ins If you do not have Power BI Tiles add-in, click on Find more add-ins at the Office Store and search for Power BI Tiles … Continue reading POWER BI TUTORIAL: SURFACING POWER BI DASHBOARD IN POWERPOINT
Power BI Desktop : Merge Query Options
In Power BI Desktop, there are multiple options available when using Merge Query feature. This tutorial reviews each of the options. Data for the tutorial can be obtained by downloading Excel file from here . The file has Product sheet which has details of all the products my company sells The file also has a … Continue reading Power BI Desktop : Merge Query Options
Enabling Power View in Excel 2016
In Excel 2016, click on File -> Options -> Add-Ins From the drop down select COM Add-ins and select Go… In COM Add-Ins dialogue, if Power View for Excel is not selected, select the check box and click OK Notice that enabling the Add-In does not provide the ability to create a Power View report … Continue reading Enabling Power View in Excel 2016
POWER BI TUTORIAL : HOW TO SURFACE EXCEL REPORTS IN POWER BI SERVICE
There are a couple of options to surface Excel Reports in Power BI Service. Download the sample file to OneDrive. The file contains a PivotTable report and a Power View report. Sign into PowerBI.com and from the left panel click on Get Data From the Get Data screen, click on Get button under Files section … Continue reading POWER BI TUTORIAL : HOW TO SURFACE EXCEL REPORTS IN POWER BI SERVICE
Power BI Tutorial: Transform data from folder data source
Data for the tutorial can be obtained by downloading CSV files from: https://www.census.gov/popest/data/intercensal/state/ST-EST00INT-02.html For the tutorial I downloaded data for Alabama, Alaska and Arizona into a folder. Open the CSV files, and notice that all of them have the same layout. In this tutorial we are going to: Read data from the folder data source … Continue reading Power BI Tutorial: Transform data from folder data source
Power BI Desktop Tutorial: Building a Star Schema from an Excel Source
An updated version of this tutorial (including a video lecture) is available here: https://businessintelligist.com/?p=2718 This tutorial shows how to create a Star Schema using Power BI Desktop. Data for the tutorial can be obtained by downloading Excel file from here Very often our analysis starts with a flat data set that contains all of the … Continue reading Power BI Desktop Tutorial: Building a Star Schema from an Excel Source
Power BI Tutorial: UnPivot Feature
It's common that data is laid out across columns in Excel for reporting purposes. E.g. Revenue for each product is laid out across the columns in excel for each month. However this may not work well as a data source. Power Query provides Unpivot option to solve this issue. Sample workbook can be downloaded here. … Continue reading Power BI Tutorial: UnPivot Feature
Power BI Tutorial: How to Parameterize Connection Variables in Power Query
While migrating a power query solution across environments (Dev to UAT to Prod) changing connection variables for each power query is a tedious task. Here is a way to make the connection variable dynamic. The sample here has two power queries connecting to SQL server source. Create an excel table and call it Parameter with … Continue reading Power BI Tutorial: How to Parameterize Connection Variables in Power Query
business intelligist 