Category: PowerBI desktop

Show sales only for corresponding months in prior years

{ 2 Comments }

Refer to this simple Sales dataset The objective is to create a simple matrix with months in the row labels, years in the column labels and sales figures in the value area section.  The twist in the question is that for years prior to the current year (2018 in this dataset), sales should only appear […]

Read More →

Filtering on 2 date fields within one Table

{ 0 Comments }

This table contains a list of all the inspections created and completed within different time periods. The objective is to create two Tables from this single table – one showing the Accounts created within the chosen time period and another showing the those that were closed within the same time period.  Here are screenshots of […]

Read More →

Discover insights with the “Sand Dance” visual, query your dataset with Natural Language Queries and Cortana integration

{ 2 Comments }

This post is in continuation of an earlier post where I applied Excel’s Business Intelligence tools (PowerPivot, Power Query and PowerView) to analyse the Sales data of an E-Commerce Company.  So, just for starters, in that post, I have basically sliced and diced the Sales dataset of an E-Commerce Company from multiple perspectives/facets to know the […]

Read More →

Visualising data flows using Custom Visuals

{ 0 Comments }

Assume a 4 column dataset (a small sample) as follows: City of Origin City of destination Mode of Transport Passengers travelled New Delhi Pune Air 123 New Delhi Mumbai Air 213 New Delhi Kolkata Air 125 Chandigarh Jammu Bus 785 Chandigarh Amritsar Train 567 Given this dataset, one may want answers to the following questions: […]

Read More →