Showing results for 
Search instead for 
Did you mean: 

Welcome to the forum!

Hello to tod@s!

My name is Miguel Escobar. A little over 1 year ago I started a forum through my company(Powered Solutions)focused mainly on topics related to Power BI, Power Query and PowerPivot totally in Spanish.

Yes! Just like you read it. A totally free forum for the entire Spanish-speaking community where we helped each other as a community by answering daily inquiries of any kind of complexity level.

All this effort arose because there was no free public community or forum for Power BI-related topics, nor was there much content published in Spanish for these topics compared to what exists in English.

We understood very well the impact of having an active community and content created in Spanish for a tool like Power BI / Power Query / PowerPivot and that's why we take reins on the issue to have a positive impact on Spanish-speaking users looking for such communities and content.

Thus, at the end of 2018 our campaign for the Spanish-speaking community emerged internationally where the forum was one of the main contributions.

Just during all this time the forum was active, I was always in touch with the Microsoft team so they could monitor the impact that the forum we had created. I hope the forum has served you as a sample of what an official Power BI forum could be in Spanish.

An ordinary day comes to me excellent news – the Microsoft team has a new system that can be implemented on the official Power BI forum/community (which was only in English) to be able to make syndicated content or, to put it another way, have a forum/community entirely in Spanish that could then be translated into English and the content in English could be translated into Spanish through this content syndicate system.

For the past few weeks I have been in conversations with the Microsoft team to test this system and just today this new forum/community and system have been released. You're just reading this new post from the new official Microsoft Power BI forum in Spanish 😊

This was always my goal. That the forum/community was under Microsoft's domain and is known as the official one for Power BI and I think this syndication system is the right one.

This post is simply a small personal blog that I wanted to share with everyone to give them a little more context about how we got to where we are right now.

Because of this great new effort by the Microsoft team, and to merge communities that don't compete with each other, I've decided to unsubscribe from the Powered Solutions forum to give way to this new forum in Spanish.

I want to thank all the people who registered and participated in the Spanish-based Powered Solutions forum and I hope to register and become active members of this new site.

Here are some general forum statistics in the time it was active:

  • 700 registered members
  • 500 themes created
  • 2K posts posted
  • 57 connected members at the same time was our most connected!

Again, thank you to all those who supported us throughout this time and to new members for being part of this great global Spanish Community of Power BI.

-Miguel Escobar

Community Support
Community Support

Hi @miguel ,


Thank you for sharing and hope you can do better in the future.


Best regards,

Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

New Member

Congratulations Miguel, for reaching this goal!!!
Not applicable

Congratulations Miguel; I've really learned a lot from your forums and with this great scope I'm sure many more will get it too.

Congratulations Miguen for such a great achievement God Bless you

First of all thank you GOD for such an excellent opportunity and thank you to Miguel for his contributions to this Hispanic community and that God continues to bless him very much so that he can continue to share his knowledge and now we will learn more.

Frequent Visitor

Excellent @miguel

You know I'm always on order...

Congratulations on this super important step...


Helper I
Helper I

Hello Miguel:

I've already managed to get in, now to start this new stage.

Best wishes

Best regards.

New Member

Hello miguel,

Thank you very much for your effort, we are gradually growing as a Spanish-speaking power bi community.

Best regards
New Member

Good afternoon

I am in a working group which is being presented with the following inconvenience and would like to know if they could help me solve it.

I have a dashboard that is recalculating the mix effect, price and current sales volume vs. budgeted sales. This mix effect, price and volume is displayed at the level of different categories and/or filters (Country, brand, product). When including the formula for calculation e.g. Price effect and select two countries at the time, the price effect shown to me is being calculated taking into account the total income of the countries / Total units of the two countries. Which is a very different result if you calculate the price effect of each country separately and add it up. (I include image with example).


What I'm needing is for my dashboard to still apply the included filters, respect me the price effect for each country and add it up instead of focusing it on total revenue and units.

I was told that this could be solved using the SUMX formula, yet I have not managed to fix it. In advance a thousand thanks for your collaboration with the concern!

Best regards.

Frequent Visitor

Hello I would like to know if anyone can help me in a power bi table.

I loaded the following table from a sports page, it would look like this:

Ranking League Player Position Team Total Goals

1 Messi Forward FCB 19

2 Benzema Front RMA 14

3 Roger Forward LEV 11

3 Lucas Péraz Forward ALA 11

3 Luis Suarez Forward FCB 11

I'd like to add a new column where they put the team goals ranking.

It would look like this.

Ranking League Player Position Team Total Goals Team Ranking

1 Messi Forward FCB 19 1

3 Luis Suarez Forward FCB 11 2

Here we see where Messi is the 1 in the league ranking and team ranking.

And Luis Suarez is No. 3 in league rankings, but he would be 2 in the team rankings.

Well this does not come out, I have tried everything with the RANK(ALL, a thousand combinations, or give me error or give me a value 1 in all boxes.

See if anyone can help me with this.

Thanks for the collaboration.

A greeting


Helpful resources

November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!


Power Platform October Community Highlights

Check out the top community contributors across all of the communities


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors