How to sort date hierarchies in descending order in a hierarchical slicer in Power BI

In the world of business intelligence, the ability to efficiently analyze data from complex systems such as Microsoft Dynamics NAV (also known as Navision) and Business Central is critical. In Power BI, hierarchical slicers are a powerful tool to effectively filter and analyze data. A common challenge is to analyze all levels of a date hierarchy (such as year [...]).

How to quickly add a date table in Power BI

The Power of Data For Success

If you use data from systems such as Microsoft Dynamics NAV, its predecessor Navision or the newer Business Central in Power BI, the integration of a date table is often indispensable. It enables deep time-based analysis of your business data. In this article we will show you how to implement this efficiently. 1. why a data table is important: Before we start [...]

Customized evaluation of categories with the DAX function RANKX

The Power of Data For Success

In Microsoft Dynamics NAV, also known as Navision or Business Central, the ability to effectively analyze and organize data is critical to the success of a business. A common question asked is: How can you rank categories or items according to a specific metric such as revenue? This is where RANKX comes in, a powerful [...]

Welcome Manuel!

The Power of Data For Success

Welcome aboard - Manuel John! We are pleased to introduce our new contributor, who joins us with an impressive background in computational linguistics. In his studies, he conducted a fascinating project training a ChatGPT model to generate plays in the style of Goethe and Schiller. His solid knowledge of [...]

BI Technologies in Transition: Today vs Tomorrow

The Power of Data For Success

Changing technologies for BI Microsoft technologies are constantly evolving. In the following, I would like to present various compilations of technical components that can be used to implement professional business intelligence projects today and in the future. Current technology stack for SQL Server On Premise Customers who already have a SQL Server in-house due to other projects (at least Standard Edition) come [...]

Field Switch in Power BI: Simplify your data analysis with dynamic column selection

The Power of Data For Success

Effective data analysis is critical for companies that use Microsoft Dynamics NAV, Navision and Business Central as their ERP systems. Power BI, Microsoft's powerful business intelligence tool, offers a feature called Field Switch that lets you dynamically select columns and simplify your data analysis. In this article, you will learn how to use the Field Switch [...]

Data-based color change of rows in Power BI tables or matrices

The Power of Data For Success

Visualizing data in table format is an effective way to present information and gain insights. In Microsoft Dynamics NAV, Navision and Business Central, popular ERP systems from Microsoft, data analysis plays a crucial role for businesses. In this article, you'll learn how to change the color of rows in Power BI tables or matrices based [...]