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 Wednesday - last edited Wednesday

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

Read more...

'What If' Analysis Techniques For Power BI

by EnterpriseDNA Regular Visitor Wednesday - last edited Thursday 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...

The Power BI World Tour is back! These value packed two-day events will take place in eight cities over the course of four months. Registration is open – secure your seat today to engage in this local learning opportunity!

 

PowerBIWorldTour.png

Read more...

MBAS_General Banner Ad_728x90.png

Time is running out! Join our community, partners, and experts at Microsoft Business Applications Summit.

Read more...

Multivalued column is a database design pattern where instead of normalizing and splitting data across multiple tables you keep multiple values in a single column. When used, this pattern requires extra modelling to work great in Power BI. This article explains how to do it!

Read more...

Power BI Global Challenge Sweepstakes

by Power BI Admin ‎06-27-2018 11:58 AM - edited ‎07-03-2018 09:43 AM

Global-Challenge-Facebook.jpg 

Calling all Power BI fans and social change enthusiasts!  Want to share your Power BI skills with community members and present data that will inspire change? Here’s your chance!  Grab some data that is meaningful to you, use Power BI to bring the data to life, show us how you put everything together in a video, or submit your data report. 

Read more...

PUG World Tour

by Power BI Admin on ‎06-22-2018 11:51 AM

It’s baaaaack! The PUG World Tour will be kicking off this summer, so be sure to register for a conference near you.

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

The winners of the 2018 PUG Data Visualization Shootout were announced at Data & BI Summit in Dublin. Four industry experts competed for prizes and bragging rights at a fast-paced contest hosted by MVP Markus Ehrenmueller.

Read more...

MBAS_General Banner Ad_728x90.png

Get ready to connect, collaborate and pack in as much learning as possible at Microsoft Business Applications Summit, the event for Dynamics 365, Power BI, Excel, PowerApps and Flow users, July 22-24 in Seattle. We’ve just announced our featured speaker lineup – you won’t want to miss these experts, plus three amazing keynotes. Check it out!

Read more...

This blog shows how different Business Intelligence tools are similar to each other.

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

Infographic Designer Update - Version 1.7.3

by infonice Visitor on ‎05-17-2018 07:10 PM - last edited on ‎05-22-2018 08:47 AM 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.

Read more...

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.

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

Power%20BI_Excel_banner%20ad_728x90_MBAS.png

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!

 

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

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!

Read more...

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

 

 

Read more...

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

Read more...

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! 

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

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

Read more...

Power BI for: Ever ?!

by Super User ‎03-30-2018 08:54 AM - edited ‎06-28-2018 03:44 AM

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

Read more...

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

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

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.

Read more...

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