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.

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

Read more...

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

 

Read more...

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.  

Read more...

Attachment

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.

Read more...

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.

Read more...

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

by Super User on ‎02-22-2018 10:44 AM - last edited on ‎02-26-2018 10:13 PM by Power BI Admin MindyJ

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.

Read more...

Fun with Graphing in Power BI - Part 1

by Super User on ‎02-14-2018 12:59 PM - last edited on ‎02-22-2018 10:48 AM by Power BI Admin MindyJ

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.

Read more...

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.

Read more...

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 MindyJ

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.

Read more...

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 MindyJ

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.

20be95_c186be1858a54501bac3e0a33e8fd4d9-mv2.png

 

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

https://community.powerbi.com/t5/Data-Stories-Gallery/Business-Schools-Dashboard-France/m-p/187496.

Read more...

Attachment

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

 

 

 

 

 

 

Read more...

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 MindyJ

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.

Read more...

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

Read more...

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.

Read more...

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.

Read more...

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 MindyJ

Measure enterprise Power BI usage with Office 365 Audit Logs.

Read more...

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

Read more...

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 MindyJ

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.

Read more...

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 MindyJ

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.

Read more...

Toggle between a chart and a table

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

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.

Read more...

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 MindyJ

Use PowerShell to maintain Power BI / Office 365 Groups. 

Read more...

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 Power BI Admin mbenjamin

 

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).

Read more...

Comment Spam Policy Update for Power BI Community Forums

by Power BI Admin MindyJ ‎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.

Read more...

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.

Read more...

Attachment

Using Change Tables to Compare Data

by Super User on ‎10-12-2017 09:32 AM

Have you ever wanted to compare changes in your data without having to create duplicate copies, as well as make it really simple and easy for users to do some self-service comparisons?

In this example I am going to show how I created and then used Change tables to compare data where you can select multiple items to compare.

Read more...

Walk Through Of Many Ranking Techniques using DAX in Power BI

by EnterpriseDNA Regular Visitor on ‎10-09-2017 01:49 PM - last edited on ‎10-09-2017 01:50 PM by Power BI Admin mbenjamin

There's so many applications and situations where utilising ranking techniques really add a lot of value in your analysis.
 
I've created many videos over at Enterprise DNA TV which showcase these techniques, so I thought I might review some of these here so you can learn about them more.
 
I'm going to review these techniques but don't forget you could apply these a number of different ways and in lots of situations.
 
1. Find Your Top Customers Through Time Using RANKX in Power BI w/DAX
2. Discover Top Salespeople Contribution To All Sales in Power BI w/DAX
3. Discover The Best Selling Day For Your Products w/DAX in Power BI

 

Enterprise DNA TV logo2.png

Read more...

Thanks to all of you who were able to attend my webinar today titled Power BI Embedding Version 2 – The Full Story. I am starting to get the idea that people in Norway are head-over-heels-crazy for Power BI. I say this because our good friend, Hans Kristiansen of Capgemini, was able to gather 79 Norwegians members of his local Power BI user group into a single room to participate my webinar today. For those of you who are interested in the content but were unable to attend, I have posted to webinar recording in the Webinars and Video Gallery of the Power BI community site at this link.

Read more...

New Webinars on Advanced Query Design and Power BI Embedded

by TedPattison Member ‎08-03-2017 05:58 PM - edited ‎08-03-2017 05:59 PM

 

After receiving 12 Microsoft MVP awards my work with SharePoint development, this week I finally received my first MVP award for Power BI and the Microsoft Data Platform. I guess you could say I am a Born Again MVP! I am very happy to be in the company of so many of my Power BI heroes such as Marcus Russo, Alberto Ferrari and Chris Webb. To celebrate this achievement I have scheduled two public webinars on Power BI next week in which I am going to present some in-depth content. I hope you can make it to one of these webinar and, afterwards, I will post the recordings to the Power BI community site for those who are interested but cannot attend due to time constraints.

Read more...

Pivot your Data using Power Query

by Excelside Established Member ‎08-02-2017 07:28 AM - edited ‎08-02-2017 08:01 AM

Yes, you read it right ! I am not going to talk about unpivot, which is probably one of the most powerful feature in Power Query, but Table.Pivot which happened to be useful for me a few days ago.

Read more...

Attachment

image.pngA Power BI Custom Connector for Youtube Analytics

Read more...

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