Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Find articles, guides, information and community news

Most Recent
Ritaf1983
Super User
Super User

Scenario:

Let's assume I have a factory with a large number of machines. These machines produce different products. The factory operates 24 hours a day.

Read more...

v-xinruzhu-msft
Community Support
Community Support

Scenario:  

In the use of Power BI's built-in visual objects, some users wish to annotate certain values in line charts. However, Power BI's built-in visual objects do not provide this functionality. As a workaround, we can use Python to create a line chart and annotate some special data points in it. Let's take a look at the example below.  

Read more...

v-tangjie-msft
Community Support
Community Support

Scenario:
In some cases, we may need to split string fields into columns based on specific conditions. The purpose of this article is to illustrate how this can be accomplished using M functions for a specific case.

Read more...

ibarrau
Super User
Super User

Let's take a moment to chat about a Power Bi external tool. For some time now, there are several well-known tools that we use more and more every day to support our developments in Power Bi Desktop and beyond. This tool, in particular, is gaining popularity for "data modeling cleanup," but we can use it for other purposes as well.

This article introduces the tool Measure Killer so we can learn about its main free features and analyze if we want it to accompany us like many others

Read more...

Fowmy
Super User
Super User

Discover a simple, DAX-free method to highlight maximum and minimum data points in your Power BI visuals, enhancing insights effortlessly through conditional formatting.

Read more...

v-jingzhan-msft
Community Support
Community Support

In Power BI, we will encounter the many-to-many relationships frequently. Typically, when faced with this situation, we always create a bridge table to establish connections and process the data. However, creating a bridge table will involve the calculation of more than three tables, and it may lead to circular dependencies sometimes. As an alternative, in certain scenarios, we can explore using the Cartesian Product to handle the data. Let's look at a sample in the next sections.  

Read more...

v-tangjie-msft
Community Support
Community Support

Scenario:
In some cases, we may need to construct a table that contains only those entries that satisfy certain filtering criteria. The purpose of this article is to illustrate how to use the Dax or M function to achieve this function.

Read more...

Fowmy
Super User
Super User

Discover how to automatically update your Power BI date filters including Date Slicers and visuals to the latest date from your fact table.

Read more...

Fowmy
Super User
Super User

Check your data for issues and anomalies in your tables. Make it easier for everyone to understand by adding a data profiling report tab in your Power BI report. I'll guide you through creating one using simple steps, including how to use the GUI data profiling and Table.Profile function for more insights.

Read more...

v-xinruzhu-msft
Community Support
Community Support

Scenario: 

In this post, tooltip and measure are utilized to show the breakdown of data for different classifications. 

Read more...

Salamalhasan
Employee
Employee

In this blog, I'll show you how to use Lakehouse's SQL analytics for efficient data warehousing. I'll guide you through the process with practical examples, making it easy to ingest data into Lakehouse and access it in Fabric Datawarehouse.

Read more...

ibarrau
Super User
Super User

The world of DAX is on fire with the release of new functions at the end of 2022. Many posts on various blogs have appeared showing many scenarios explaining the new functions.

Most articles try to explain the functions. This article will overlook that and will try to compare how time intelligence functions respond with traditional code compared to the new DAX functions to solve those classic date scenarios.

Read more...

v-jingzhan-msft
Community Support
Community Support

Scenario: 

Sometimes when we create a report, we may want to implement a complex data sorting in visuals according to multiple ranking rules. This is not easily done by sorting by a single column or ranking by a single expression. We will need some DAX techniques to get there.

In this article, we want to sort car brands in a table visual according to several rules. And when a ranking is selected, a dynamic display includes the two car brands prior to the selected ranking.

Read more...

v-tangjie-msft
Community Support
Community Support

Scenario:

In this article, we'd like to achieve a scenario that distributes a table's data into two visuals for displaying while still filtering them with a single slicer.

 

The detailed requirements are: Create a report with two table visuals and one slicer visual. Two table visuals are created with the same table fields but the data that showed is different, e.g. each table visual could only display half of the data. And when we select items in the slicer, two table visuals will render the data according to the selections.

Read more...

v-xinruzhu-msft
Community Support
Community Support

Scenario:   

There are various types of visuals in Power BI that we can use to create a beautiful report to get business insights from data. However, sometimes a visual may not be able to satisfy some certain requirements. If it is an open-sourced visual, you may have a choice to modify its code to meet your specific requirement. In this article, I will take Gantt 2.2.3 chart as an example.  

customer recently used Gantt 2.2.3 charts in Power BI Desktop and the customer noticed that the maximum number of its tooltips was 3. When trying to put more fields in it, it shows yellow lines and it doesn't seem to allow any more fields to be added to it. Below I will explore how to overcome this limitation for this visual.  

Read more...

Helpful resources

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