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.

Infographic Designer Update - Version 1.7.3

by infonice Visitor on ‎05-17-2018 07:10 PM - last edited Tuesday by Power BI Admin

Infographic Designer is a Power BI custom visual that help you beautify your reports and dashboards with easy-to-create infographics and small-multiples.


Malcolm Gladwell_Facebook_MBAS.png

Hear from bestselling author and like-minded analytics aficionado Malcolm Gladwell in a special closing keynote. Plus! Explore the session catalog.


Switching Dimensions Based on Slicer Selection

by ThirdI Frequent Visitor on ‎05-16-2018 04:49 AM - last edited Tuesday 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.



We’re excited to announce registration is open for the first-ever Microsoft Business Applications Summit, coming to Seattle July 22–24! Combining the best of the Microsoft Data Insights Summit, Convergence, and the Dynamics 365 Technical Conference, this new event is designed to help you create the best, lasting solutions for your business. Don’t wait – secure your spot today!



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

by Super User on ‎04-30-2018 09:32 PM - last edited Tuesday 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!



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.


PUG Global Hackathon

by Power BI Admin on ‎04-18-2018 10:42 AM

There’s still time to join your local PUG and participate in the PUG Global Hackathon!


Ready to learn how to use Power BI at a strategic and functional level to drive your business forward?




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


Power BI "Space" Contest winners!

by Power BI Admin on ‎04-09-2018 05:14 PM

Mercury may be in retrograde, but that didn't stop you from creating some fun space-themed Power BI reports. Congrats to the winners! 


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.



Things I'm pretty excited about after seeing the BizApp Spring Launch Event


Power BI for: Ever ?!

by Super User on ‎03-30-2018 08:54 AM

Short vent of my enthusiasm about the CDM and CDSA prestented in the business application virtual launch


The Buisness Applications Virtual Spring Launch that aired on 28th of March, puts a lot of stress to my personal time schedule, but it has been worht the effort ....


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.  



Power Adoption Seminar 2.png


Plan ahead for self-service BI success
Roll out your self-service business intelligence (BI) adoption of Microsoft Power BI with success. Attend the webinar that outlines the role of governance in Power BI adoption. Learn the different governance approaches for different types of BI solutions, as well as the roles and responsibilities needed for an effective self-service BI practice.


Space and Space Exploration Contest

by Power BI Admin ‎03-15-2018 02:58 PM - edited ‎03-16-2018 03:38 PM

Share a report about space or space exploration to participate in this contest. See official rules for details. 


Happy Pi Day! 3.14...

by Power BI Admin ‎03-13-2018 04:51 PM - edited ‎03-14-2018 11:59 AM

Let's have some fun celebrating this milestone math day!



MVP Global Summit | March 4-7

by Power BI Admin ‎03-05-2018 10:36 AM - edited ‎03-05-2018 10:41 AM

MVP Banner.PNG

The MVP Global Summit is happening this week in Redmond, WA.  We are super excited to connect with all the MVP's and welcome them to our communities.


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.


Register for a free Power BI Adoption Framework Webinar

by Power BI Admin ‎02-27-2018 02:39 PM - edited ‎02-27-2018 02:44 PM

Power Adoption Seminar.png


Purchasing Power BI is just the first step in a data driven culture journey. Driving Power BI adoption inside an organization requires a change in people, processes and technology.  Microsoft has developed a structured approach and a methodology to successfully drive organizational adoption of self-service BI.


Fun with Graphing in Power BI - Part 3i

by Super User on ‎02-26-2018 10:08 PM - last edited Tuesday 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.


Focus 2018 Early Bird Pricing ENDS WEDNESDAY, FEBRUARY 28

by Power BI Admin ‎02-23-2018 03:17 PM - edited ‎02-23-2018 03:22 PM



There’s still time to register for Focus at a discounted price.  Early Bird Pricing is available through Wednesday, February 28! Take advantage of this great deal and save $100 instantly.


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

by Super User on ‎02-22-2018 10:44 AM - last edited Tuesday 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.


Introducing: The Datanauts

by Power BI Admin on ‎02-21-2018 09:49 AM

It’s a bird… It’s a plane… It’s DATANAUTS!  


You may have noticed shiny new ranks next to some familiar faces, and I’m pleased to introduce our very first generation of Datanauts 


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

by Dianapo Visitor on ‎02-20-2018 04:46 PM - last edited on ‎04-03-2018 10:16 AM by Power BI Admin

This multi-part tutorial blog is geared to help BI Analysts create versatile Scorecards with KPIs as well as to facilitate the business reporting transition from Excel, SSRS or other apps to Power BI Desktop.


In this initial installment, I will illustrate how to include more than one aggregation and custom formatting in the Power BI Desktop Matrix. All tutorial steps below require acquaintance with how Power BI Desktop works as well as basic to advanced DAX skills.


Fun with Graphing in Power BI - Part 1

by Super User on ‎02-14-2018 12:59 PM - last edited Tuesday 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.


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