cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
Microsoft
Microsoft

Use the UNICHAR function and Unicode to create visuals.

Read more...

Memorable Member
Memorable Member

Customers ask you to show total values in a bar-chart for all years along with each year individually.

 

FarhanAhmed_0-1601358870005.png

Read more...

Microsoft
Microsoft

In this blog, I will explain how a redundant ‘Return’ statement in a Power BI Measure can cause huge performance issues.

Read more...

Resolver I
Resolver I

In practical business, data iteration is widely used, such as present value or depreciation. However, as we all know, DAX is a functional language based on column engine, each row of data is calculated based on its own row context. But sometimes ...

 

Iteration in DAX.png

Read more...

Microsoft
Microsoft

In this blog, I would like to address one of the issues that I came across recently with the RANKX function where the Ranking Score is different, even though the Sales Amount is exactly same.

Read more...

Super User II
Super User II

I often get asked about best practice on when to use a lot of smaller measures that refer to each other VS when to write the entire expression as one long measure. If you have a great answer to this question, I'd love to hear your perspective, but this post provides one example of how lots of smaller measures can sometimes come in handy. 

Read more...

Super User IV
Super User IV

Power BI Time Intelligence provides powerful functions to deal with Year, Quarter, and Month. But WTD and this Week vs Last Week do not have any out-of-the-box solution. Let’s quickly deal with Week Time Intelligence.

Read more...

Super User II
Super User II

Power BI supports a functional language called DAX (Data Analysis Expressions), which basically represents an executable piece of code inside a function. DAX expressions can sometimes be difficult to use and understand. There are multiple DAX expressions out there, but today I will be concentrating on a problem statement for using the RANKX function, and how to resolve it.

Read more...

Super User I
Super User I

This article will show how to create a Calendar table with T-SQL, Power Query and DAX languages that are necessary to do correct data modeling.

Read more...

Super User II
Super User II

There are situations in which you want to use a ranking of rows based on one column, but that column has non-unique values. Sometimes, there are other columns you want to use, if two rows have the same value in the primary ranking column.  In this blog, I want to explain step by step how ranking based on multiple columns (more than 2!) can help you solve this problem in DAX. The pattern used is something I picked up in this community, the focus in this blog is on the inner workings of that pattern.

Read more...

Advocate I
Advocate I

title.png

 Change Source in Power BI Desktop is disabled

 

Changing a Data Source connection in Power BI Desktop is very simple, just two or three clicks, as you can see in these two very simple methods:

 

article_pwbi_1.png

 

Although it is a simple step to change the connection of a Data Source in Power BI Desktop, sometimes we face a problem that makes this change difficult, when the option button [Change Source ...] is disabled, which forces us to change manually within the Power Query Advanced Editor.

 

article_pwbi_2.png

 

So, first we need to understand the logic that Power BI uses and why this option appears disabled. Everything happens within Power Query, as you can see, the first step we cannot exclude, precisely because Power BI understands that every first step of each query will be the Data Source. That is, if we start a query creating a variable instead of starting with the connection to the Data Source, the option to change the Data Source in the simple way you saw at the beginning of this article will be automatically disabled.

 

article_pwbi_3.png

 

Conclusion:

 

What can we do to fix this problem? We need to create these variables in a separate query, so we can use these variables in any other Query and at any step of it, but not in the first, as you can see in the image below. Also, it is a good practice of queries organization.

 

article_pwbi_4.png

 

 

So, the first step of Query will always be the Data Source and you will always have the option button to change the Data Source activated, because Power BI will always find your first stage of Query your Data Source.

 

article_pwbi_50.png

 

Thank you for reading and give your feedback. 🙂

 

Regular Visitor

Our customers often ask us in our projects or workshops why Power BI is so successful in the area of Business Intelligence. Besides all the advantages like Self-Service BI (especially for non-technical persons), connectivity to a lot of data sources, creation of stunning reports and dashboards, great possibilities for sharing and collaboration etc. there is one big reason for it: DAX!

Read more...

Super User III
Super User III

Custom visuals are great and there is a variety of solutions that they help us solve.

 

From simple table formatting options to advance analytics with forecasting neural networking.

 

But can you emulate custom visuals without importing them from the store?

 

Read more...

Regular Visitor

Multivalued column is a database design pattern where instead of normalizing and splitting data across multiple tables you keep multiple values in a single column. When used, this pattern requires extra modelling to work great in Power BI. This article explains how to do it!

Read more...

Helpful resources

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