Power BI

Spent some time experimenting with the excellent “Synoptic Panel by OKViz” custom visualisation and came up with the idea of finding a different way to visualise the costs associated with a companies organisation structure. Organisation Chart & Associated Salaries and Costs Report  Image 1: Report showing Total Salaries and Costs for a fictitious organisation.  The Organisation Chart diagram in … Continue reading "Power BI – Visualisation – Org Chart"

Traditionally, when we do variance analysis, we compare the actual value of the metric being measured to its target value in either absolute or relative terms. For example, if I were to compare cur…

Microsoft's Guy in a Cube has been providing tips and tricks for Power BI and Business Intelligence on his YouTube channel since 2014. Every Thursday we highlight a different helpful video from…

Hi All,   I would be most grateful for some help with my DAX formula for a calculated measure please. I have a fact table 'Fact' and a parameter table 'Reference' (disconnected slicer).   'Fact' consists of three columns: Transactions, Category, Sales - this is at transaction level, i.e. if a custo...

Hi,   I'm looking to create a report that shows monthly totals for the last x months, then for the current month, I'd want it to be able to show a forecast of where the month will get to based on the numbers so far this month.   I have played around with the in-built forecasting tool, but that doesn...

Line charts are indespensable, but they can get pretty busy pretty quick. A chart with several related measures can have so many lines on it that they turn into an indistiguishable visual mess. Wouldn't it be great to give users a chart that's got several measure on it, but it allows them to turn in...

Power View performs advanced statistical analysis of the data in your line charts to generate forecasts that incorporate trends and seasonal factors. If you want to learn more about these methods and how to customize your forecasts to get the best results...

Technical articles, content and resources for IT Professionals working in Microsoft technologies

Scenario A retail firm believes that its sales are driven by an external index that we will call the "Real Wage Index". This index tracks real hourly wages adjusted for inflation, seasonality, etc. The retail firm believes that this index is a 3-month leading indicator, meaning that when the index g...

Out of 407 Total Combinations of Subcategory and Region, These 8 Stand Out This Month (These 8 Combinations Differed GREATLY from their Respective 12-month

Trick on how to use slicers in PowerBI to pass values as query parameters to the underlying M-queries. Allowing multiple values and query folding.

In February, we announced that our Microsoft Data Insights Summit will return for the second year, and invited you to register and join us June 12-13, 2017 in Seattle, WA. This is THE user conference for Power BI, SQL Server BI, Excel, PowerApps, and Flow. See what sessions we have planned for this amazing event!

Hello Power Query enthusiasts,   many of you know that Power Query is an amazing tool for data import and data transformation. It is powerful an easy to use. But there is always a BUT. It is a pain to write custom M code. The Power Query Advanced Editor comes without intellisense (auto completion), ...

You may have seen some forum posts showing how to filter a report with a URL query string parameter. We also have this in the main documentation as well. It isn’t very widely known. So, I thought I’d do a blog post to highlight how to do it, and also give you a trick you can use to filter on multiple fields.

I created a measure that it is accurately giving a running count over a subset of the data Nb cumulatif de DDS_ALL = CALCULATE ( COUNT ( '311_Details'[DDS] ); FILTER ( ALL('311_Details');('311_Details'[Nature]"Information")&&( '311_Details'[Date de Création]

I have a line chart with 13 months in the dataset. 12 month from the past and 1 for the upcoming month. This is calculated data in our database. I want to plot these 13 months but make more clear that the last month is not actual information, but a forecast.   Is there a way to make a part of a grap...

Hi,    I have a dimension table "CUSTOMER" with all customers and a fact table "SALES"   A Create a measure to sum sales and other to rank customers   1. $ Total Sales = SUM(SALES_VALUE) 2. Rank = RANKX( ALLSELECTED(CustomerName);[$ Total Sales])   When my customer don't have sales, i would like to ...

Over the past 3 years, I have collected data at the US County Level.  In this dataset, I have over 100 columns of data for every county in the United States ( 3,100 counties).  This includes data from the US Census, Center for Disease Control, the Bureau of Labor Statistics and presidential electio...

We are very excited to announce the launch of the new theme gallery in the Power BI Community. This gallery is a dedicated space for you to share and find new themes for use in your Power BI reports.

I recently had a question from a user in the Power BI Community page who wanted to know where the people were coming from based on their IP Address. The IP addresses were stored as part of the data…

Learn how to make a dashboard that allows for faster and better business decision making by following our dashboard creation tips & tricks.

A brief description on how to use the New Power BI Features including the New Matrix Preview, and the Custom Report Themes.

A quick update here on the football project (not really warranting a video).  The source db is awfully complex, and I’m in the process of wrapping my

I am tracking KPIs for some sales reps, so I have a table of all the sales calls they made witih a column that shows what sales method they used (Cold Calls, Meeting, Etc.)  Each sales rep has chosen a single type of method, and and goal number of calls for that method they must make a week, so in a...

For me, Stephen Few has always been the guru of Data visualisations. Recently, while I was reading one of his paper, I came across most talked Bullet Chart and Highlighting a…

R Scripts and Power BI What is R-script? R is a language and environment used for statistical and graphic computing. It is a modification of the S