Summer party 2024: A day full of surprises and team spirit
On Sunday, June 23, 2024, data4success GmbH held its annual summer party, and it was a day we all won't soon forget. With bright sunshine and good humor, our teams and their families met for a special event: the Surprise Tour by SharingPlate. A culinary adventure in Frankfurt To [...]
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 [...]).
Introduction to the Power BI Report Builder for Microsoft Dynamics NAV and Business Central users
Introduction The Power BI Report Builder is a Microsoft tool designed for the creation of paginated reports. These reports are particularly suitable for printing or exporting to formats such as PDF. The Report Builder is part of the Power BI ecosystem and offers tight integration with Microsoft Dynamics NAV (Navision) and Business [...]
How to quickly add a date table in Power BI
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
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 [...]
Fix Many-to-Many Relationships in Power BI: The Power of Bridge Tables and Bidirectional Cross Filtering
In the world of data analysis and business intelligence, Power BI has established itself as an indispensable tool for turning data into meaningful insights. But Power BI users often encounter a particular challenge: many-to-many relationships. In this article, we'll explore how to solve this problem using a bridge table and implementing Bi-Directional Cross Filtering [...]