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.

Switching Dimensions Based on Slicer Selection

by ThirdI Frequent Visitor Wednesday - last edited Friday 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.


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

by Super User ‎04-30-2018 09:32 PM - edited ‎04-30-2018 09:34 PM

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!



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.



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.



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.  



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.


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.


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 ‎02-26-2018 10:13 PM 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 ‎02-22-2018 10:48 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.


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


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.


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.


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.


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.


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. 


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.


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.


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


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


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.


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.


How to use your Office Theme as Power BI Report Theme

by DominikPetri Regular Visitor on ‎07-12-2017 01:10 PM - last edited on ‎10-24-2017 09:41 AM by Power BI Admin

Since Power BI Desktop’s March 2017 Update, it is possible to apply a color theme to your entire report. When you apply a so called “Report Theme”, all visuals in your report use the colors from your selected theme. Unfortunately, you can’t just import your Office Theme Colors into Power BI Desktop since they have different structures and filetypes. Therefore, I developed an Excel tool (the download link is at the end of the article) that converts your Office Theme into a Power BI Desktop Theme in 4 simple steps.


screen.pngExcel tool to convert an Office Theme into an Power BI Desktop Theme


Power BI - Overview Infographic

by Super User on ‎06-26-2017 03:54 PM

With there being so many changes and updates to Power BI, I have created an infographic in which it covers all of the vital elements when looking at Power BI Free, Pro and Premium.


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