Power BI

Ways we can get to the total's row in Table or Matrix visual using HASONEVALUE & INSCOPE functions in Power BI

RANKX is a simple function used to rank a value within a list of values. Its use is simple, but it can be a source of frustration for newbies. In this artic

I have been blogging about DAX since before Power BI was a product; I started back in 2014 and Power BI was first released as generally available in mid 2015.  Until about 2017, the only way you could build a commercially viable production reporting tool that used DAX was via [...]Read More »

Analyze, visualize, and report on your data using 92 new DAX functions when creating measures in Power Pivot.

In this writing, I like to share what I have learned about OFFSET DAX function, that recently came out to the world, but not yet documented on https://learn.microsoft.com/en-us/dax/ as of today. When I face the situation to measure date-intelligence-related business requirement, I use SAMEPERIODLASTYEAR, DATESINPERIOD, DATEADD, and so many other time intelligence DAX functions, if a business is using normal & general calendar table. Or, I use FILTER, MIN, MAX, and some other DAX functions, if

A few data traps that data consumers and data storytellers alike should beware of to avoid getting the wrong idea

Timeline Storyteller, a new custom visual for Power BI I created with a team of other researchers at Microsoft, is now available in the Office Store for anyone to use. Power BI is a powerful data storytelling tool, and with Timeline Storyteller, data journalists can now visualize a sequence of events in a compelling way using the large palette of design options that Timeline Storyteller provides. Learn more about this latest custom visual from the Microsoft Research team.

Happy Friday all! Last week, we announced the latest preview of Power BI Report Server, which included new functionality like additional data source support and support for viewing Excel Workbooks.…

You can connect an Excel workbook to a Power BI model in two ways: Using the Analyze in Excel action in powerbi.com Using the Connect to Data action in the

R scripts in Power BIs query editor are a very convenient way to quickly expand your analytical toolbox. Here are some points to watch out for:

A very convenient way to store your collection of R (or M-) functions in Power BI is a record which serves as a function library: R-function-library

Late last month Microsoft released the certification exam for Power BI, 70-778: Analyzing and Visualizing Data with Microsoft Power BI. The exam is currently in beta and will likely remain that way…

So I’ve been working on a fun little project over the past couple weeks. A lot of my customers have questions related to Power BI and I spend a lot of my time answering those questions. So I said t…

Here is this week’s BI Round up with the latest weekly information. Power BI – On-Premise Gateway update for August As you can see above in the August update there is now support for IBM Nete…

Here is the weekly BI Roundup of what has been happening in the last week. Power BI – User details in Usage Metric Reports As you can see in the image above, the Power BI team has now incorporated …

Zoe Helps Me Answer a Long-Simmering Question This summer we welcomed Zoe Stein (an Industrial Engineering major from Georgia Tech) to the team for a summe

Please join me and other 2017 PASS Summit speakers for 24 Hours of PASS: Summit Preview on July 19th and 20th.  24HOP is a series of 60 minute on-line sessions presented back-to-back for 24 ho…

Thought I’d post my initial impressions of installing Power BI Report Server. Unless you’ve been disconnected from the web for any length of time, you’ve heard of Power BI. In May 2017, Microsoft r…

In this module you will learn how to use the Dot Plot Custom Visual by MAQ Software.  The Dot Plot is used to show distribution using dots among multiple categories or attributes. Module 64 – Dot P…

Local government is always looking for ways to target its resources more effectively. Lancashire County Council's business intelligence team recently began exploring Power BI as a powerful platform to visualise Lancashire's latest data for health and its wider determinants at neighbourhood level.   ...

NAME: Arrow Rating   DESCRIPTION: This quick measure shows an up arrow or down arrow when comparing a target value against a target value, or else "--" if not. Can also be inverted if a lower value is better compared to the target.   PARAMETERS: Name: Base Value Tooltip: Your base value / measure. T...

Hello, I want to calculate the time difference of same type occurrences. What I already did was to get my data in the following format by duplicating the table (and adding index columns, one beginning with 0 and the other with 1) and merging them by means of a outer join. Then I added a calculated...