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

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.  

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.

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

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.

Scenario: 

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

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.

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.

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.

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.

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.  

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

Scenario: 

In this article, we would like to realize circular dependency columns using M function “List.Accumulate” in Power Query.

Unlock the power of precise working day calculations! Learn how to exclude holidays and weekends for accurate insights in your data analysis. Calculate Working days excluding weekends and Holidays. Calculate fore-cast Date without include of weekends and Holidays

Can You Count the Substring Occurrences?

In some scenarios, we need to use RLS to restrict user’s access to certain data, but this can conflict with certain calculations involving overall data, such as rankings. In this article, I will show you how to achieve this.