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.

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

by TedPattison Member on ‎11-01-2017 04:06 PM - last edited on ‎11-02-2017 01:34 PM by Power BI Admin MindyJ

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.

Read more...

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

 

 

 

Read more...

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 Power BI Admin mbenjamin

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

Read more...

How to use your Office Theme as Power BI Report Theme

by DominikPetri Regular Visitor on ‎07-12-2017 01:10 PM - last edited on ‎10-24-2017 09:41 AM by Power BI Admin mbenjamin

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.

 

Excel tool to convert an Office Theme into an Power BI Desktop ThemeExcel tool to convert an Office Theme into an Power BI Desktop Theme

Read more...