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.

The "Disconnected Table Trick" is a fairly well known technique in the world of Power BI but I could not find a community blog article that actually presented it. This article explains and demonstrates the use of the Disconnected Table Trick in the context of solving a recent problem around tracking and reporting attendance that came up at a recent Columbus Azure ML and Power BI User Group (CAMLPUG) meeting.



Using Change Tables to Compare Data

by guavaq Super Contributor on ‎10-12-2017 09:32 AM

Have you ever wanted to compare changes in your data without having to create duplicate copies, as well as make it really simple and easy for users to do some self-service comparisons?

In this example I am going to show how I created and then used Change tables to compare data where you can select multiple items to compare.


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


London and Copenhagen wrapped up their two-day Power BI World Tour events in August. To read more about the highlights from the World Tour events in London and Copenhagen, check out the event recaps.


Thanks to all of you who were able to attend my webinar today titled Power BI Embedding Version 2 – The Full Story. I am starting to get the idea that people in Norway are head-over-heels-crazy for Power BI. I say this because our good friend, Hans Kristiansen of Capgemini, was able to gather 79 Norwegians members of his local Power BI user group into a single room to participate my webinar today. For those of you who are interested in the content but were unable to attend, I have posted to webinar recording in the Webinars and Video Gallery of the Power BI community site at this link.


New Webinars on Advanced Query Design and Power BI Embedded

by TedPattison Member ‎08-03-2017 05:58 PM - edited ‎08-03-2017 05:59 PM


After receiving 12 Microsoft MVP awards my work with SharePoint development, this week I finally received my first MVP award for Power BI and the Microsoft Data Platform. I guess you could say I am a Born Again MVP! I am very happy to be in the company of so many of my Power BI heroes such as Marcus Russo, Alberto Ferrari and Chris Webb. To celebrate this achievement I have scheduled two public webinars on Power BI next week in which I am going to present some in-depth content. I hope you can make it to one of these webinar and, afterwards, I will post the recordings to the Power BI community site for those who are interested but cannot attend due to time constraints.


Pivot your Data using Power Query

by Excelside Established Member ‎08-02-2017 07:28 AM - edited ‎08-02-2017 08:01 AM

Yes, you read it right ! I am not going to talk about unpivot, which is probably one of the most powerful feature in Power Query, but Table.Pivot which happened to be useful for me a few days ago.



A Power BI Custom Connector for Youtube AnalyticsA Power BI Custom Connector for Youtube Analytics


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 ‎07-21-2017 03:37 PM by Jessica Regular Visitor

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



Power BI - Overview Infographic

by guavaq Super Contributor on ‎06-26-2017 03:54 PM

With there being so many changes and updates to Power BI, I have created an infographic in which it covers all of the vital elements when looking at Power BI Free, Pro and Premium.


We are very excited to give you a preview of what each of our 18 amazing customers will show you during the Customer Story sessions at the Microsoft Data Insights Summit on June 12 – 13 in Seattle. After much preparation, we've boiled down each presentation to 25 minutes with 5-10 minutes of every session focused on demos.


We've made sure we have depth and breadth of customers across several industries like sports, finance, technology, media, and more with many different capabilities showcased, including Microsoft Power BI, Power BI Mobile, PowerApps, R, Azure Machine Learning, IoT, and more. Here's a quick look at what you can expect during the event!


In this blog post I show how to use Unicode characters to further leverage Power BI visuals within a table.


Meet Datanaut Flox!

by Jessica Regular Visitor ‎06-08-2017 10:29 AM - edited ‎06-08-2017 10:30 AM

This week we announced some of the community events you can expect at the Microsoft Data Insights Summit next week, and debuted the Datanauts, a collection of space defenders representing Excel, PowerApps, Flow, and Power BI.


Today, meet Flox.


Meet Datanaut Appleta Patel

by Jessica Regular Visitor ‎06-07-2017 12:55 PM - edited ‎06-07-2017 12:57 PM

This week we announced some of the community events you can expect at the Microsoft Data Insights Summit next week, and debuted the Datanauts, a collection of space defenders representing Excel, PowerApps, Flow, and Power BI.


Today, meet Appleta Patel.


Meet Datanaut Xander Cell

by Jessica Regular Visitor ‎06-06-2017 11:59 AM - edited ‎06-06-2017 12:05 PM

Yesterday we announced some of the community events you can expect at the Microsoft Data Insights Summit next week, and debuted the Datanauts, a collection of space defenders representing Excel, PowerApps, Flow, and Power BI.


Today, meet Xander Cell.


First look at Power BI Report Server

by darogael Frequent Visitor on ‎06-06-2017 11:46 AM

Power BI Report Server Preview was made available early May 2017 and this blog walks you through the installation, configuration and ends with a demo. The demo video shows how a report can built and added to the Power BI Report Server.


Can't make it to Microsoft Data Insights Summit? We’ll bring the conference to you!


We’re livestreaming our three keynotes and nine of our most popular breakout sessions, June 12–13, 2017 so you can learn alongside attendees. As Microsoft’s conference for business analysts, the Microsoft Data Insights Summit is filled with strong technical content to help you build a data culture at your organization.


See the full livestream schedule in this post. Mark your calendar and get ready to transform the way you work!


Creating Slopegraphs in Power BI

by deldersveld Established Member on ‎05-22-2017 09:21 AM

Did you know that it's easy to transform Power BI's Line Chart into a Slopegraph? No DAX or fancy workarounds are required. Slopegraphs are a great way to judge the rate and magnitude of change by looking at the steepness of a line’s slope. With a slopegraph, it is also easier to discern how different elements or categories trend compared to others.


Slopegraph Sample


Last week we launched the Power BI Blogroll! It's a place for external bloggers to share the best of their own posts, and for readers to stay on top of what folks from around the world are saying about Power BI. Read on to learn more about the blogroll and how you can participate...


Extracting Report Level measures DAX using SQL Profiler output

by XLGeek Visitor ‎05-15-2017 04:58 PM - edited ‎05-15-2017 05:01 PM

In the May 2017 release of Power BI Desktop a new ‘report measures’ feature was released. It allows users who have connected Power BI Desktop to an external Analysis Services tabular model to write their own measures using DAX. These measures are stored within the report, and sent in the queries back to the underlying model. Any user who has access to query the model can do this – just the same as if they were using Excel or SQL Management Studio to connect to the SSAS server.



Don’t forget to submit your Power BI Pride 2017 videos – the deadline is quickly approaching (due: May 14, 2017).


Known for his award-winning global achievements in infographics and multimedia as a professor, author, journalist and designer, we are excited to welcome data visualization expert Alberto Cairo back to the Microsoft Data Insights Summit, taking place June 12-13, 2017 in Seattle. This year Alberto will provide a special guest keynote focused on the different dimensions of data visualization and how to entice your audience to engage with your information.


As I remember managers used to love SSRS reports for their availability of traffic light indicators which are useful way of measuring KPIs, trends etc. During my recent Power BI engagements with clients I have been asked few times if similar can be achieved in Power BI and my answer to that was, yes by pinning SSRS reports into Power BI which is essentially using SSRS and only with version 2016 but during the process I also discovered alternative approach which I want to highlight below.


Through utilizing the flexibility of the Power BI data model and the power of DAX you can develop some unbelievably compelling visuals and reports. I'm going to take you through the steps you need to take to make this work well, so that you can create reports like this....I call this technique MULTI THREADED DYNAMIC VISUALS


dynamic vsiuals.JPG


Learn how to get the most from your data — and the Microsoft tools you use every day — at the Microsoft Data Insights Summit, the company’s user conference for business analysts. Now in its second year, the event is packed with strong technical content, hands-on workshops, and a great lineup of speakers. And back by popular demand, you can now book an appointment with a Microsoft expert with our recently launched online Schedule Builder.


Hi, everyone!


Are you an avid user of Power BI products? Are you passionate about your language's quality? If so, a new forum (Power BI Language Quality) will allow you report and discuss language quality issues. You can also ask about Power BI Localization team, their processes and product languages. Your feedback will help us improve localization experience of Power BI products!

The list of supported languages are described in Power BI documentation.  


How to report language translation issues for Power BI on this forum (https://community.powerbi.com/t5/Power-BI-Language-Translation/bd-p/PBI_Lingusitic_Quality )?


Post your translation issue in the group & include the following information

Power BI Product/App/Service Name:

Language affected:

Current Translation:

Steps to reproduce the error:

Suggested Translation:

Corresponding English Text (if known):

Reason for change:

Please attach a screenshot of the issue to the post if available.

Platform if known.

Power BI Free vs Pro Infographic

by guavaq Super Contributor on ‎04-18-2017 05:01 PM

I have created an Infographic where you can view which options are free and which options require a Pro license. 


This will hopefully make it easier to understand if you use a particular option, if it will require a Pro license.


The previous blogs in this series showed how to put Power BI on top of Trello. Now we go for the jugular ad build a full-on data model. 


Once Power BI is connected to Trello, it then needs to look at the actual Trello cards. Here's how.