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.

Important Considerations for Setting up Incremental Refresh on Power BI Desktop

by Kumail Regular Visitor on ‎10-27-2018 01:28 AM - last edited on ‎11-13-2018 04:48 PM by Administrator await

Are you working on big data and want to leverage the powerful capabilities of Power BI desktop? Then Incremental Refresh is a key feature to learn. It makes data refreshes faster and more reliable with less resource consumption.


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

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.


Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Power BI

by TedPattison on ‎11-01-2017 04:06 PM - last edited on ‎11-02-2017 01:34 PM by MindyJ Frequent Visitor

So many people on the Power BI team at Microsoft have been working day and night for the last two years making the Power BI platform and its constantly-evolving feature set more competitive against Tableau, the industry leader. Those of us outside of Microsoft in the Power BI community can also help to make Power BI more competitive against Tableau by working together to increase the amount of Power BI expertise in our industry. Power BI adoption numbers are sure to increase as companies become more confident in the fact that they can find the right people with the talent and skills to design custom Power BI solutions and to manage the wide-scale distribution of content published to the Power BI service. This is why Power BI certification will become increasingly important as we move into 2018.


Recently I ran a free workshop for all of those connected to Enterprise DNA in some way. It was all about dashboarding and how to develop really compelling reports. Here's the reporting dashboard I showcased as I ran through my best practice visualization techniques - I'm making it available for download here along with the workshop recording


Multi Year Performance.JPG





Walk Through Of Many Ranking Techniques using DAX in Power BI

by EnterpriseDNA Regular Visitor on ‎10-09-2017 01:49 PM - last edited on ‎10-09-2017 01:50 PM by mbenjamin Member

There's so many applications and situations where utilising ranking techniques really add a lot of value in your analysis.
I've created many videos over at Enterprise DNA TV which showcase these techniques, so I thought I might review some of these here so you can learn about them more.
I'm going to review these techniques but don't forget you could apply these a number of different ways and in lots of situations.
1. Find Your Top Customers Through Time Using RANKX in Power BI w/DAX
2. Discover Top Salespeople Contribution To All Sales in Power BI w/DAX
3. Discover The Best Selling Day For Your Products w/DAX in Power BI


Enterprise DNA TV logo2.png


How to use your Office Theme as Power BI Report Theme

by DominikPetri on ‎07-12-2017 01:10 PM - last edited on ‎10-24-2017 09:41 AM by mbenjamin Member

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


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