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.

'What If' Analysis Techniques For Power BI

by EnterpriseDNA Regular Visitor on ‎07-11-2018 07:17 PM - last edited on ‎07-12-2018 10:41 AM by Power BI Admin

In this post, I want to dive into 'What if' analysis and why it is so powerful to utilize this technique inside your Power BI models and reports.

 

When utilizing 'What if' parameters, you can run scenarios and scenario type analysis on your data. With this, you can look forward or look historically and analyze what would have happened if a different scenario had played out.

 

What if image.png

 

 

 

Read more...

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:

https://app.powerbi.com/view?r=eyJrIjoiMDg2YmVlOWYtMDdmYS00OTg2LWI2MDgtMDU3NDlhYWZjYjVjIiwidCI6IjRmM...

 

Summary.png

Read more...

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

Read more...

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.

Read more...

Fun with Graphing in Power BI - Part 5-by-5

by Super User on ‎04-30-2018 09:32 PM - last edited on ‎05-22-2018 09:06 AM by Power BI Admin

This is the latest post in my series "Fun with Graphing in Power BI". It might be my last as well. There are a few different reasons for that. First, and most importantly, I believe I may be running out of cool, nifty tricks to show you in Power BI. Second, I am most definitely starting to run a bit thin on lame math jokes. Third; comparatively, this one was really, really difficult!! All that being said, I may give the Koch Snowflake a go or maybe the Sierpinski Carpet. Who knows, if you want to see this series continue, leave something encouraging in the comments!

Read more...

Attachment

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

Read more...

Attachment

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.

Read more...

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

Read more...

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.

 

Read more...

Fun with Graphing in Power BI - Part SQRT(POWER(SQRT(8),2) + POWER(SQRT(8),2))

by Super User on ‎03-28-2018 04:13 PM - last edited on ‎05-22-2018 09:10 AM by Power BI Admin

Ah yes, the Pythagorean Theorem. Many a young lass has been woo'd by the dulcet sounds of the Pythagorean Theorem being gently whispered in her ear. And by many, I mean absolutely zero...in like the entire history of mankind. So, while the Pythagorean Theorem has nothing to do with helping you get a date, it does have something to do with this next article in my Fun with Graphing in Power BI series.

Read more...

Attachment

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

Office 365 Groups reporting and Power BI visualization

by AlexHolmeset Frequent Visitor ‎03-01-2018 11:39 AM - edited ‎03-01-2018 11:41 AM

Complete Office 365 Groups reporting script integrated with Power BI.

Read more...

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

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.

Read more...

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.

Read more...

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.

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

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.

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 2

by rsaprano Frequent Visitor on ‎01-30-2018 10:31 AM - last edited on ‎01-30-2018 10:34 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. Part 1 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...

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.

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

Measure enterprise Power BI usage with Office 365 Audit Logs.

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

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

In this blog post we will take a look at how to automate the process of updating the data in the Power BI report we created in part 2, without needing a computer or server. We will do this by scheduling a Runbook in Azure Automation.

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

Use PowerShell to maintain Power BI / Office 365 Groups. 

Read more...

Integrating PowerShell with PowerBI: Module, script and reporting (Part 2)

by AlexHolmeset Frequent Visitor on ‎11-21-2017 02:41 AM - last edited on ‎12-06-2017 03:43 PM by Power BI Admin

In my last blog post, Integrating PowerShell with Power BI (Part 1), I set up the connection between Power BI and PowerShell.  If you followed the steps in part one, you are set to start using this newly created integration.  In this post I will take a look at how we use the Power BI module and how to visualize the data in Power BI reports.

Read more...

Integrating PowerShell with Power BI (Part 1)

by AlexHolmeset Frequent Visitor on ‎11-21-2017 02:27 AM - last edited on ‎12-06-2017 03:40 PM by Power BI Admin

Power BI is an extremely powerful data and visualization tool. It has opened a new world for me. But, the first thing I always think about when looking at Microsoft products is that there must be a way to control this with PowerShell. I did not find any useful information about any PowerShell module on the product pages.  After some googling, I found a module on the PowerShell gallery potentially created by a Microsoft employee.  What's surprising is that the module has been out for about 7 months and has barely 130 downloads.  Why hasn’t this been more popular? Hopefully I can help change this with a series of blog posts looking at the possibilities of Power BI and PowerShell.

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

Read more...

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

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