cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
Fowmy
Super User
Super User

I'll show you how to elevate your data visualization game using Power BI with "One Chart - Two Insights!" technique, you'll learn how to create a powerful Power BI Line Chart that displays both actual and budget data comparison using Error-Bars, all in one dynamic view.

Read more...

technolog
Super User
Super User

Dive into the intricacies of outputting multiple values in a measure using DAX functions. From utilizing the TOPN function to leveraging the power of SELECTCOLUMNS, we'll guide you step-by-step on how to display product sales data in descending order. Plus, discover the magic of CONCATENATEX and how to seamlessly merge text for a comprehensive view of your data.

Screenshot 2023-09-17 at 23.08.54.png

Read more...

truptis
Super User
Super User

We can now specify the order by using "BLANKS FIRST" & "BLANKS LAST"

Read more...

technolog
Super User
Super User

Discover different methods for creating summary tables in DAX code and explore the nuances of each function, from SUMMARIZE to GROUPBY and SUMMARIZECOLUMNS. Learn how to efficiently aggregate data, handle grouping, and incorporate aggregation functions to achieve the desired summary results.

Screenshot 2023-09-03 at 18.35.17.png

Read more...

ibarrau
Super User
Super User

Every day the cloud grows and grows even more. The trust and security it provides are standing out, strengthening the bond with its users.

The on-premises Power BI solution consists of a Report Server attached to SQL Server. This version has its limitations compared to Power BI Service, which constantly brings us many attractive features.

This article will teach us how to migrate reports published in Power BI Report Server to Power BI Service with the help of the SimplePBI python library.

Let's find out how to migrate reports published in Report Server to Power BI Service in three steps

Read more...

technolog
Super User
Super User

Ever puzzled over how to optimally rank products by their sales amounts or the number of orders in your data model? Dive into our comprehensive guide as we unravel the intricacies of the RANKX function using the Orders table as a foundation. We'll journey through constructing summary tables, navigating the challenges of filter contexts, and ensuring accuracy in rank calculation. Plus, get insights into advanced techniques like calculating profit through computed columns and differentiating rank computations in measures versus computable tables. Join us to decode the art of effective ranking with DAX and enhance your analytics prowess.

Screenshot 2023-08-29 at 00.45.19.png

Read more...

technolog
Super User
Super User

Unlock the secrets of calculating sales sums and shares for each department! Dive into a step-by-step guide that breaks down the complexities of data visualization, from summing up sales across departments to understanding product category shares. Discover alternative calculation methods, the power of filter contexts, and the nuances of functions like ALL, VALUES, and ALLEXCEPT. Whether you're a novice or a pro, this article offers insights into making your data work for you

Read more...

technolog
Super User
Super User

Ever thought about summarizing your 'Orders' table by product category using DAX? Dive into our step-by-step guide on how to build a product summary table leveraging the power of the SUMMARIZE function. We'll break down:

  • Techniques to calculate totals and subtotals in your summary table.
  • A neat workaround using the ROLLUPGROUP function to get precise total values.
  • Advanced DAX code to convert multiple columns into one and retrieve scalar values for specific calculations.

Whether you're a DAX novice or a seasoned professional, this article promises insights that can revolutionize your table summarization process.

Read more...

danextian
Super User
Super User

What if the Web connector cannot detect  a table or cannot generate a table with the information needed using Add Table Using Examples feature? A good example are image URLs.

Read more...

nandukrishnavs
Community Champion
Community Champion

The objective is to implement a functionality that enables the dynamic modification of the number of bars displayed in the visual, based on the slicer selection, while concurrently altering the axis.

Read more...

danextian
Super User
Super User

Power Query is a very powerful tool to scrape information from public webpages. It can be as simple as entering the URL and selecting the desired table. But what if the information needed is from the same table but across multiple web pages?

Read more...

Arul
Super User
Super User

Comparing Selected Month Sales against other months Sales using INDEX DAX function.

Read more...

Pragati11
Super User
Super User

"A day without a challenge, is a day without a learning!"

Today, I got a requirement from a client, where they asked for getting data labels along with icons along with conditional formatting, on top of the bars represented in a clustered column chart. Now this is something I had not done before, so started looking at various ways in Power BI until I achieved it.

Just to highlight here - conditional formatting is my favourite part of data visualisation in Power BI. I like to have challenges in this area as it keeps me to skill-up myself. There are many folks out there who have amazing blogs on conditional formatting tricks in Power BI, but there is a reason why I want to share my approach today related to this requirement.

Read more...

Ritaf1983
Community Champion
Community Champion

Graph from the "don't try this at home" drawer or a story about how the user sometimes doesn't know what he needs.

Read more...

SpartaBI
Community Champion
Community Champion

In a Power BI Embedded App Owns Data implementation, targeting Paginated Reports, it is possible to overcome the character size limitation on RLS filter values. 
This can be beneficial in a variety of scenarios, one of which is using Kusto as a data source (aka Azure Data Explorer, aka Microsoft Fabric Real-Time Analytics). 

Read more...

Helpful resources

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