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.

I wanted to run through some fantastic visualization techniques that you can incorporate into your Power BI models and reports.  The first one is what I call Multi-Threaded dynamic visuals and the second one is Multi-Measure dynamic visuals.

 

Picture1.png

 

 

 

 

 

Read more...

Scenario Analysis (What Ifs) Tips & Techniques For Power BI

by EnterpriseDNA Regular Visitor on ‎11-04-2018 04:18 PM - last edited on ‎11-08-2018 02:01 PM by Administrator await

Today, I wanted to cover in detail some fantastic scenario analysis techniques you can use inside of Power BI. Power BI is an amazing tool if you want to predict what may happen in the future or alternatively see what could have happened in the past based on certain variables changing in your data.

 

community.png

 

 

 

Read more...

SSO FAQs

by Administrator vrisch on ‎11-02-2018 06:39 AM - last edited Wednesday by Administrator jfeil

Here are some FAQs to help you troubleshoot your sign-in challenges . . . 

Read more...

The Power BI Community Has Made a Big Change!

by Administrator await ‎10-31-2018 06:55 AM - edited ‎10-31-2018 08:36 AM

We’ve made a big change to the Power BI community! We’ve streamlined the sign-in process so that when you’re signed in to Power BI, you’ll be signed into the community. No need to keep track of separate passwords or credentials with the ‘single sign on’ experience.

Read more...

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.

Read more...

Fixing Total Errors In Power BI - I Know It Can Be Frustrating

by EnterpriseDNA Regular Visitor ‎10-25-2018 07:25 PM - edited ‎10-25-2018 07:41 PM

With today's post I wanted to run through some examples of how you can solve errors in your totals within Power BI. Via the Enterprise DNA Support Forum, I get to see a lot of issues and requests that users who are working in Power BI Desktop have.

 

community 1026.png

 

 

 

Read more...

The Power BI Community is Making Changes: More Details!

by Administrator await on ‎10-24-2018 06:35 PM - last edited on ‎11-02-2018 06:40 AM by Administrator vrisch

On October 31, we're rolling out a big change to the Power BI community. We’re streamlining the sign-in process – once you’re signed in to Power BI, you’ll be signed into the community. No need to keep track of separate passwords or credentials with the ‘single sign on’ experience!

Read more...

Iterating Functions - SUMX & AVERAGEX, Why You Need To Understand These Well

by EnterpriseDNA Regular Visitor ‎10-18-2018 04:49 PM - edited ‎10-18-2018 05:43 PM

If you are creating some analysis inside of Power BI and you’re utilizing DAX measures, then having a superior understanding of how ITERATING functions work is very important. This is what this particular post will showcase to you - understanding how important these functions are.

 

community blog.png

 

 

 

Read more...

Working With Financial Years In Power BI

by EnterpriseDNA Regular Visitor ‎10-11-2018 07:19 AM - edited ‎10-11-2018 07:23 AM

In today's post, I wanted to cover a few examples of how you can incorporate financial years into your Power BI models and reports. Sometimes, your date tables won’t have the custom financial years that you require for your analysis. Not only could it be financial years but you might also need to bring into filters your financial quarters.

 

community blog.png

 

 

 

 

Read more...

Developing with Power BI Embedding (Part 2)

by TedPattison on ‎10-08-2018 05:42 AM - last edited on ‎10-09-2018 06:25 AM by Administrator await

In Part 2 of this blog series, I will discuss the purpose of dedicated capcities and explain the differences between Power BI Premium and Power BI Embedded. I will also provide the neccessary details so you can choose the right type of dedicated capacity for a particular scenario.

Read more...

Financial Reporting Tips For Power BI

by EnterpriseDNA Regular Visitor on ‎10-04-2018 04:55 AM - last edited on ‎10-08-2018 06:33 AM by Administrator await

In this post I wanted to go into a few financial reporting tips you can utilize inside Power BI. Many of you who have been using Power BI since it was re-released a few years ago know that financial reporting inside of the tables we were given has been relatively difficult.

 

community blog.png

 

 

 

 

Read more...

Developing with Power BI Embedding (Part 1)

by TedPattison on ‎09-30-2018 07:44 PM - last edited on ‎10-01-2018 02:37 PM by Administrator await

Power BI provides developers with Platform-as-a-Service (PaaS) capabilities which make it possible to embed Power BI resources into custom applications. By learning to use a set of APIs created by the Power BI team at Microsoft, a developer can embed Power BI reports, dashboards and dashboard tiles into custom web applications that target the browsers, tablets and mobile devices.

Read more...

Cumulative Totals In-Depth - The Many Variations In Power BI

by EnterpriseDNA Regular Visitor ‎09-27-2018 04:49 PM - edited ‎09-27-2018 04:57 PM

Today, I want to talk about cumulative totals. I want to do a deep dive into a few ways that you can create these inside of Power BI. In this first tutorial, I want to show you the most common pattern which you can utilize to create cumulative totals in a dynamic way.

 

community blog.png

 

 

Read more...

Best Practices For Power BI Desktop Development

by EnterpriseDNA Regular Visitor ‎09-20-2018 05:37 PM - edited ‎09-20-2018 05:39 PM

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...

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...

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...

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...

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...

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...

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...

'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

 

 

 

Read more...

Follow the World Cup in Power BI

by ruthpozuelo on ‎06-18-2018 04:54 AM - last edited on ‎06-19-2018 10:30 AM by MindyJ Frequent Visitor

Do you have the World Cup fever yet? 

 

That is where Power BI comes to the rescue.  Smiley Happy

 

I have built a Power BI file to follow the World Cup and I decided to show you how I created it while creating it.  Smiley Happy

 

You can download it at the end of the post if you want it or follow it live here:

https://app.powerbi.com/view?r=eyJrIjoiMDg2YmVlOWYtMDdmYS00OTg2LWI2MDgtMDU3NDlhYWZjYjVjIiwidCI6IjRmM...

 

Summary.png

Read more...

Conditional Formatting in Power BI Tables

by Hardik Established Member on ‎05-29-2018 09:34 PM - last edited on ‎05-31-2018 05:42 PM by MindyJ Frequent Visitor

An Easy Way to Convert Boring Tables Into a Meaningful Insight

Read more...

Switching Dimensions Based on Slicer Selection

by ThirdI Frequent Visitor on ‎05-16-2018 04:49 AM - last edited on ‎05-22-2018 10:00 AM by MindyJ Frequent Visitor

I recently came across a customer who was looking for a way to switch the dimensions dynamically using a slicer.  In this blog, I’ll be sharing how I could do it in Power BI. This can be understood using the following example:

 

Switching the dimensions of a bar chart between Daily and Monthly based on the slicer selection.

Read more...

Fun with Graphing in Power BI - Part 5-by-5

by Super User on ‎04-30-2018 09:32 PM - last edited on ‎05-22-2018 09:06 AM by MindyJ Frequent Visitor

This is the latest post in my series "Fun with Graphing in Power BI". It might be my last as well. There are a few different reasons for that. First, and most importantly, I believe I may be running out of cool, nifty tricks to show you in Power BI. Second, I am most definitely starting to run a bit thin on lame math jokes. Third; comparatively, this one was really, really difficult!! All that being said, I may give the Koch Snowflake a go or maybe the Sierpinski Carpet. Who knows, if you want to see this series continue, leave something encouraging in the comments!

Read more...

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