Welcome to the Power BI Community Blog!

On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news.

And the award goes to Power BI

by gurukpm Frequent Visitor ‎07-11-2018 09:30 PM - edited ‎07-11-2018 09:39 PM

Thanks to Power BI for solving our issues and giving an award-winning performance for Redmond Tamil School!


Follow the World Cup in Power BI

by ruthpozuelo Regular Visitor on ‎06-18-2018 04:54 AM - last edited on ‎06-19-2018 10:30 AM by Power BI Admin

Do you have the World Cup fever yet? 


That is where Power BI comes to the rescue.  Smiley Happy


I have built a Power BI file to follow the World Cup and I decided to show you how I created it while creating it.  Smiley Happy


You can download it at the end of the post if you want it or follow it live here:





Conditional Formatting in Power BI Tables

by Hardik Established Member on ‎05-29-2018 09:34 PM - last edited on ‎05-31-2018 05:42 PM by Power BI Admin

An Easy Way to Convert Boring Tables Into a Meaningful Insight


Switching Dimensions Based on Slicer Selection

by ThirdI Frequent Visitor on ‎05-16-2018 04:49 AM - last edited on ‎05-22-2018 10:00 AM by Power BI Admin

I recently came across a customer who was looking for a way to switch the dimensions dynamically using a slicer.  In this blog, I’ll be sharing how I could do it in Power BI. This can be understood using the following example:


Switching the dimensions of a bar chart between Daily and Monthly based on the slicer selection.


Share Power BI Desktop files with R scripts without the fear of missing packages.



Calculos a la fecha, MTD, YTD

by jbocachica Member on ‎04-23-2018 03:00 PM - last edited on ‎04-23-2018 03:03 PM by Power BI Admin

Se ve sencillo, sin embargo el comportamiento de las agregaciones disponibles nativamente en DAX no es tan amable como esperaba.


In this blog post I show how to use the new Parameters options in the Power BI Service.


Power BI Desktop: Custom Aggregations, Formatting and Performance Indicators (Part 2)

by Dianapo Visitor on ‎04-03-2018 10:09 AM - last edited on ‎04-17-2018 04:30 PM by Power BI Admin

 part2final.JPGIn part 2, gives step by step instructions on how to add color performance indicators based on the associated target.



Switch from Excel & PowerPoint to next-Gen dataviz (for Beginners)

by augustindelaf Member ‎03-22-2018 12:33 PM - edited ‎03-22-2018 12:33 PM

The purpose of the following article is to help people who would like to create simple dashboards for their Excel data, and to show them how easy it is.


Let's start with a very common issue we all faced once.  You have (a lot of) data in your Excel file, and until now you always built your reports with Excel charts and PowerPoint. But you have seen some Power BI reports, and you would love to be able to create some beautiful reports too.  



Dynamic TopN made easy with What If Parameter

by Super User ‎02-28-2018 04:37 PM - edited ‎02-28-2018 04:39 PM

This article shows how to use the TopN easily to enable your users to filter their data with a Slicer.


Fun with Graphing in Power BI - Part 3i

by Super User on ‎02-26-2018 10:08 PM - last edited on ‎05-22-2018 09:09 AM by Power BI Admin

Perhaps you thought there were no more fun graphing topics with Power BI after Part 1 and Part SQRT(4). Well, you would be wrong. You see, because they hate you, mathematicians treacherously strive to invent new ways to confound and befuddle actual human beings nearly every day. In 1975, one particularly vicious mathematician, Benoit B Mandelbrot used hundreds of years of research to create perhaps one of the most devious, spiteful and sadistic mathematical constructs...the fractal.


Fun with Graphing in Power BI - Part SQRT(4)

by Super User on ‎02-22-2018 10:44 AM - last edited on ‎05-22-2018 09:08 AM by Power BI Admin

Ah yes, stupid math humor. It's like the i talks to pi joke. You know, the one where i says to pi "Be rational!" and pi says to i, "Get real!". No? Oh well. You're probably better off that way.


Fun with Graphing in Power BI - Part 1

by Super User on ‎02-14-2018 12:59 PM - last edited on ‎05-22-2018 09:08 AM by Power BI Admin

I am always interested in pushing the limits of Power BI and, as my recent entry into the 2017 Year in Review Contest demonstrates, I do not feel that working with Power BI always has to be...well...entirely serious. So, let's have some fun with Power BI and push the envelope a bit by tackling some problems that one might traditionally utilize a program like Mathematica to solve.


Runge-Kutta and the Limits of DAX

by Super User on ‎02-13-2018 11:30 AM

My recent foray into solving complex numerical/engineering problems with DAX such as Kaplan-Meier Survival Curves and Linear Interpolation led me to wonder what other kinds of problems I might be able to solve using Power BI and DAX. This inquiry led me to remember one of my favorite engineering classes taught by Dr. Michael J. Rider at Ohio Northern University (ONU), Numerical Methods, and one of my favorite numerical method techniques, Runge-Kutta.


Joining tables In Power BI using Power Query and/or DAX

by ruthpozuelo Regular Visitor on ‎02-06-2018 09:54 AM - last edited on ‎02-06-2018 09:57 AM by Power BI Admin

I have done a few videos on YouTube explaining how to join tables using Power Query or DAX. If you follow the channel, you probably have seen the videos and this blog post will serve as a compilation of all the material.
However, if you are new, this will serve as a tutorial for beginners on how to joins in Power BI. Either way, I believe this post will be useful for all, so let's get started.


Create a nice-looking PBI Scoring System in 10 min (and make your Boss impressed)

by augustindelaf Member on ‎02-06-2018 07:26 AM - last edited on ‎02-08-2018 01:17 PM by Power BI Admin

The purpose of this tutorial is to create a nice visual that compares your products each to another, according to rules that you created.  In the end, your visual looks like a class of students where YOU give good/bad marks.



I had the opportunity to present this dashboard (similar data model but different topic) at Microsoft France HQ in June 2017:




Recently I put on a virtual workshop as part of the Enterprise DNA Webinar Series, which was all about how to set up your Power BI models for advanced insights. It was very well received by over 400 Power BI users who registered, so I thought I would do a review here for the community blog.


Advanced Insights with Power BI.JPG








Working with ranges (Numbers/Dates) in Power Query/Power BI - Part 1

by rsaprano Frequent Visitor on ‎01-26-2018 09:10 AM - last edited on ‎01-30-2018 10:38 AM by Power BI Admin

This 2-part blog post is for working with ranges/bands of numbers in the Edit Queries stage of Power BI. The first part covers inexact lookups - looking up a number against a set of bands/ranges and returning the appropriate band which the number sits in. The second part looks at finding overlapping ranges - the scenario where we have two ranges/bands of numbers (rather than having one number and one set of bands) and we want to see the areas of overlap between the ranges.


For all of those that had Dr. Marquarts out there, this is for you.


Mean Time Between Failure (MTBF) is a common term and concept used in equipment and plant maintenance contexts. In addition, MTBF is an important consideration in the development of products. MTBF, along with other maintenance, repair and reliability information, can be extremely valuable to organizations to help identify problematic systems, predict system outages, improve product designs and improve overall operational efficiency and effectiveness. As such, it would be beneficial to understand how to implement this metric within Power BI.


In Part 1 of this blog, we extracted Audit Log data from Office 365 using PowerShell and stored it in SharePoint for the purposes of quantifying Power BI adoption. In Part 2 we will transform and visualize the Audit Log data using Power BI.


Measuring Power BI Adoption using PowerShell, SharePoint and Power BI - Part 1

by NormYoung Frequent Visitor on ‎01-09-2018 10:12 AM - last edited on ‎01-11-2018 12:48 PM by Power BI Admin

Measure enterprise Power BI usage with Office 365 Audit Logs.


Building on Part 1 of this series, Part 2 demonstrates how to separate out individual Departments.


Kaplan Meier Survival Curves with Power BI - Part 1

by Super User on ‎01-04-2018 01:31 PM - last edited on ‎01-05-2018 12:27 PM by Power BI Admin

Inspired by a post on the Power BI Community site, I read through this fine article by Chris Short on LinkedIn Pulse, Survival Curves in Tableau with HR Data. Overall, this technique looked really interesting and I wondered if I could do something similar in Power BI. Turns out that you can and this article will show you how.


How to enable Excel Pro’s to use Power BI Datasets

by Super User on ‎12-07-2017 07:42 PM - last edited on ‎12-08-2017 04:50 PM by Power BI Admin

In the steps below, I will demonstrate how to access your Power BI Dataset through Excel. This is a great example for people who love Excel and use it as their tool of choice, but the company or organization still wants to have a single version of the data. By leveraging the steps below the data is available in the Power BI Service, as well as from Excel. NOTE: This currently only works on a PC.


Toggle between a chart and a table

by SivaMani Senior Member on ‎11-28-2017 04:24 AM - last edited on ‎12-01-2017 10:47 AM by Power BI Admin

One of the most requested requirements from the Business users is to view the data in two different visuals, usually in a chart and table. With standard configurations in Power BI Desktop, we don't have the option to do this. But, we can get this by using the Bookmark and Selection Pane.


Power BI Group management using Active Directory roles and PowerShell

by NormYoung Frequent Visitor on ‎11-21-2017 10:49 AM - last edited on ‎11-28-2017 10:50 AM by Power BI Admin

Use PowerShell to maintain Power BI / Office 365 Groups. 


Help creating your JSON file template for themes using a Power BI file

by ruthpozuelo Regular Visitor on ‎11-14-2017 09:20 AM - last edited on ‎11-17-2017 08:28 AM by mbenjamin Member


Have you tried to create a JSON file to manage the theme on your Power BI report? Not an easy task, right? I tried to do this last week, and I found it hard and confusing. Hours went by, and I was almost in the same place as when I started. My method was obviously not working, and the available documentation was not clear for me. I needed to do something else if I was going to produce a JSON file theme for my customer.  So, what to do? I use Power BI for everything, ok not everything, but almost everything. So, I used Power BI to create a documentation that I could understand, and finally my JSON file was done (or at least I did all that could be done, more on that on the later).


Comment Spam Policy Update for Power BI Community Forums

by Power BI Admin ‎11-07-2017 04:18 PM - edited ‎11-09-2017 11:12 AM

Have you posted to the Power BI community recently and noticed some subtle changes? You may have published your post but been unable to find it on the site or you may have noticed that your post now appears under “My Unmoderated Items” in your profile. In either case, you do not need to resubmit your post; it is in the moderator queue waiting for approval before appearing on the live site. The changes you are seeing are part of an update to the Power BI Community.


The "Disconnected Table Trick" is a fairly well known technique in the world of Power BI but I could not find a community blog article that actually presented it. This article explains and demonstrates the use of the Disconnected Table Trick in the context of solving a recent problem around tracking and reporting attendance that came up at a recent Columbus Azure ML and Power BI User Group (CAMLPUG) meeting.


Join Blog
Interested in blogging for the community? Let us Know.