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.

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.


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.







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.


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.







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.







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



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.


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.


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. 


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


Using VALUE parameter in RANKX

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




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


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




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.


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.


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


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.  


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


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


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!




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







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. 



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. 




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.


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



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.


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. 


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!


'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 MindyJ Frequent Visitor

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





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!




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