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 post, I want to dive into some of my best practices for Power BI Desktop development. I think bringing all these ideas together will give you a very good understanding of how I like to approach all Power BI reporting and analysis that I complete myself.

 

community blog.png

 

 

 

Read more...

If you are attending Ignite 2018, stop by to meet the Business Applications Communities Team in the Microsoft Showcase Area on Level 2 in the West Hall of the Orange County Convention Center.

Read more...

A requirement that we face very often in our projects is to be able to easily re-use multiple measures particularly when dealing with similar data models on a standard data source like for example cloud-based accounting systems like Dynamics, Xero, QuickBooks etc.

Read more...

Today, I want to touch on a really fascinating topic inside of Power BI. I call this one virtual tables. If you can start understanding how to incorporate virtual tables inside your DAX functions, you will quickly see the opportunities to extend your analysis even further.

 

p8.png

 

 

 

Read more...

09/27/18 Webinar: Using SVG Images in Power BI

by Administrator await ‎09-11-2018 04:23 PM - edited ‎09-11-2018 04:26 PM

Join Charles Sterling and David Eldersveld as they walk through how you can work with SVG images as Image URLs in Power BI.

Read more...

SWITCH True Logic In Power BI - What's Possible With This

by EnterpriseDNA Regular Visitor ‎09-06-2018 04:35 PM - edited ‎09-06-2018 05:56 PM

Today I wanted to cover what I call SWITCH True logic. If you haven't used the SWITCH function yet, you certainly should be. It's a far superior way to write complex logic which is traditionally done with nested IF statements if you come from an Excel background.

 

0907.png

 

 

 

Read more...

Non Standard Date Analysis In Power BI - 445/544 Calendars

by EnterpriseDNA Regular Visitor ‎09-02-2018 07:08 PM - edited ‎09-02-2018 07:10 PM

In this post, I want to dive into how you can run analysis in Power BI with a non-standard calendar. This is quite a common occurrence out there because not everyone works on the standard calendar and standard months, weeks, quarters, etc.

 

p7.png

 

 

 

Read more...

In this detailed post, I wanted to focus on time patterns. I will show you four different examples of ways you can utilize time intelligence functions effectively inside Power BI. Hopefully, by going through these examples you'll see the versatility of this great grouping of DAX functions available to us inside Power BI.

 

P5 Community.png

 

Read more...

How to Realize Dynamic Asymmetric Reports in Power BI / Excel

by karaoan on ‎08-28-2018 05:29 PM - last edited on ‎08-30-2018 10:42 AM by MindyJ Frequent Visitor

In this blog we cover how to realize asymmetric reporting requirements dynamically in a Power BI Matrix or Pivot Table. This is a typical requirements in financial forecasting and reporting.

Read more...

How to realize dynamic financial statements with calculated subtotals

by karaoan ‎08-28-2018 04:56 PM - edited ‎08-28-2018 04:57 PM

As I see lots of ongoing questions and misinformed comments (“Power BI can’t be used for financial statements”). Here I will cover a simple approach how you can realize financial statements with dynamically calculated subtotals like profit and loss (P/L), balance sheet, cash flow etc.

Read more...

Establish a multiform data production and communication strategy

by MirandaLi Frequent Visitor on ‎08-21-2018 02:54 PM - last edited on ‎08-21-2018 03:43 PM by MindyJ Frequent Visitor

For many of us who work in data analytics for long time, you may notice that producing great data reports and dashboards alone doesn’t always generate desired outcomes. Why? Because data reports and dashboards are usually exploratory by nature and self-service oriented. In addition, they usually don’t have rich text to explain why certain charts and data points are meaningful in what context, not mentioning the usual lack of graphical elements that make data fun and interesting to read. 

Read more...

Today, I want to run through a few different budgeting techniques and examples that you can use in Power BI. Running budgeting analysis in Power BI can sometimes become complex and difficult. The biggest reason is that a lot of times you're dealing with data at different granularities.

 

p5 blog.png

Read more...

Using VALUE parameter in RANKX

by Super User on ‎08-15-2018 12:58 AM

RANK.png

Read more...

Attachment

How to do a real VLOOKUP in Power BI (or expand just certain rows after a merge)

by Super User ‎08-12-2018 06:16 AM - edited ‎08-12-2018 06:30 AM

Merging tables with the same granularity in the query editor will return the same than a VLOOKUP in Excel. Do you know how to achieve this if there are multiple rows per key in the lookup table (and you just want to return the first ... or the last)?

Read more...

Showcasing Results For 80%/20% And Then Diving Into The Top 20%

by EnterpriseDNA Regular Visitor ‎08-07-2018 05:59 PM - edited ‎08-07-2018 07:37 PM

Have you ever heard of the Pareto rule? It is the theory that says 20% of your customers or products will deliver 80% of your profits. I have created a short tutorial around the formula and visualization techniques you can use to effectively showcase this analysis inside of Power BI.

 

P4 BI Community.png

 

 

Read more...

Join Charles Sterling and Shakun Grover as they walk through using real-world visualizations in your Power BI dashboard.  Microsoft Visio offers the perfect canvas for visually contextualizing data and depicting process flows. Using the new Visio visual for Power BI, you can easily bring alive Visio's powerful visualization capabilities right within your Power BI dashboards to drive insights and action.

Read more...

Join Charles Sterling and the creators of PowerBI.Tips and Microsoft MVPs, Seth Bauer and Mike Carlo, as they share with you their ever-increasing grab bag of Power Tricks, Tips and Tools they have published to https://PowerBI.Tips over the last 6 months.  Demos will include their latest theme generator, tips and tricks, and the latest Power BI Layouts.

Read more...

Join Charles Sterling and Reid Havens as they cover building a KPI scorecard with custom visuals in Power BI. 

Read more...

Meet the Power BI Community Super Users!

by Administrator chass on ‎08-02-2018 11:15 AM

If you have spent any time in the Power BI Community, you have probably noticed regular contributors through community blog posts, activity in the Power BI forum discussions, and authored accepted solutions.  Super Users are outstanding participants and expert users who regularly contribute useful solutions.  There advice is invaluable and shows because they are in the Top Kudoed Authors Leaderboard in the Microsoft Power BI Community.  See some familiar names?  Their community contributions and Power BI expertise continues to make the Power BI Community a valuable place.  

Read more...

RANKX is an incredibly powerful DAX function you can utilize inside of Power BI to showcase ranking type results or to discover insights based on any ranking of a particular result. There are many ways you can utilize RANKX. That's a key consideration I want to leave you with before I dive into some specific examples and particular ways you can utilize this function.

 P3 Image.png

Read more...

Join Charles Sterling and Daniel Christian as Daniel covers how PowerApps and PowerBI can provide school teachers the apps with reports.

Read more...

As an application of data visualization best practice, here's a way to draw attention to a particular dimension value (e.g. a particular product category) whilst still showing others for context, by means of a simple DAX pattern!

graph.jpg

Read more...

Attachment

In this post, I want to dive into anomalies and outliers in your data and how you can analyze and showcase them effectively inside of Power BI. What I will do is give you a quick explanation of outliers and anomalies. Then leave the rest of the information to the embedded videos to showcase the techniques in greater detail.

 

P2 - Image.png

 

 

 

 

 

Read more...

Bringing the Awesomeness of Power BI to School Children

by TaylorNathan Frequent Visitor ‎07-23-2018 06:10 PM - edited ‎07-23-2018 06:11 PM

Kids love tech!  My son asks me what I do with Power BI.  So I showed him, then he told his teacher about it and the school asked me to show Power BI to their Kindergarten class.  Check out the full story. 

Read more...

Attachment

Discover Community at the Microsoft Business Applications Summit

by MindyJ Frequent Visitor ‎07-23-2018 01:25 PM - edited ‎07-24-2018 12:50 PM

The Microsoft Business Applications Summit is here.  If you can’t be here in person, then join us online.  I will give you updates throughout the Summit to keep you update on what is happening.  Please check back often to see updates. 

 

 

Read more...

MBAS_General Banner Ad_728x90.png

Who’s going to Microsoft Business Applications Summit? Be sure to check out one of our featured sessions, “Power BI and the Future for Modern and Enterprise BI.” In this all-up Power BI session we’ll show you Power BI’s vision for unifying modern and enterprise BI and expanding self-service BI for big data. Come experience the newest capabilities available in Power BI and see what's coming next. We hope to see you there! Learn more on our event website.

Read more...

Learn how Mapbox and Power BI can use location data to tell your story using next generation maps.

Read more...

 

Keynote livestream banner_728x90_MBAS.png

The Microsoft Business Applications Summit is almost here, and even if you’re not joining us in Seattle, you can take part too – catch the opening keynote livestream on Monday, July 23 from 8:30 – 10am PDT, and learn what’s new and next for Microsoft Business Applications.

Read more...

7/17/2018 Webinar: July 2018 Update for Power BI Embedded with Ted Pattison

by MindyJ Frequent Visitor ‎07-17-2018 12:30 PM - edited ‎07-17-2018 12:38 PM

Join Charles Sterling and Ted Pattison as they walk through what is new and coming for Power BI Embedded in July 2018. 

Read more...

And the award goes to Power BI

by gurukpm Frequent Visitor ‎07-11-2018 09:30 PM - edited ‎07-11-2018 09:39 PM

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

Read more...

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