Logo
banner

Blogs

Revolutionizing DAX with the Magic of Visual Calculation in Power BI

, March 15, 202491 Views

The February 2024 update marks a transformative shift in DAX in Power BI writing with the introduction of visual calculations! Visual calculations entail defining and executing DAX calculations directly within a visual. These calculations have the flexibility to reference any data within the visual, be it columns, measures, or other visual calculations. This innovative approach […]

Read more

Enhancing Column chart for Variance Analysis in Power BI: A Step-by-Step Guide

, March 13, 202483 Views

In the dynamic landscape of business analytics, tracking and comparing sales or profit variances across different categories or countries is essential. While Power BI has been a go-to tool for visualizing data, the conventional methods of representing variances were limited. In this technical blog, we will explore how to leverage the reference line feature in […]

Read more

Implementing Dynamic Cascading Slicer To Filter the Data

, March 6, 2024144 Views

Recently, for Power BI, we encountered a requirement where we have Delivery data, and we want Slicer which gives a range of “Delivery Per Customer”(Count of Deliveries) that seamlessly integrates with all visuals in the dashboard. Specifically, a scenario where, upon selecting a date range, the “Delivery Per Customer” slicer dynamically operates on the filtered […]

Read more

Dynamic page navigation in Power BI based as per User Role

, March 1, 2024215 Views

In Power BI, providing page security and role-based access to users traditionally involves creating different workspaces or different audiences in one app workspace. However, an innovative approach is to achieve this using measures, eliminating the need for additional workspaces and audiences. In this blog post, we will explore a real-time requirement where we need to […]

Read more

How to get direct count using Fetch XML capabilities

, February 27, 2024148 Views

FetchXML in Dynamics 365 is a query language used to retrieve data from the system. It is a powerful and flexible tool that allows users to define complex queries to retrieve specific data from Dynamics 365 entities. An aggregate function into FetchXML queries, we can enhance data retrieval capabilities in Dynamics 365. Whether we can […]

Read more

Unlocking Data Agility: Leveraging Databricks to Interface with Business Central’s Complex API

, February 23, 202492 Views

Say hello to Databricks, a dynamic platform merging the power of Apache Spark with collaborative workspaces allowing flexibility to use multiple programming languages (Python, Scala, SQL) within a single environment. This versatility surpasses the constraints of predefined transformations in pipelines, allowing for more intricate and customized data transformations. Data Pipeline Hiccups: The ‘Content-Type’ Snag Let’s […]

Read more

Integration of Business Central APIs and Web Services with OAuth

, February 20, 2024302 Views

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to connect Business Central APIs and Web Service with OAuth. Microsoft Dynamics 365 Business Central, offers a set of powerful APIs and […]

Read more

Is Microsoft Dynamics 365 Business Central the best ERP?

, February 19, 2024127 Views

ERPs or Enterprise Resource Planning applications have been around for a very long time now. They started off as simple table heavy software applications leveraging computers’ ability to store data indefinitely and retrieve data at any time with speed and accuracy. Over time as databases evolved into relational databases, computers became faster and could store […]

Read more

Achieving Hierarchical Representation for Measures in Power BI Matrix Visual: A Workaround

, February 16, 2024163 Views

Greetings, BI enthusiasts! When working with Power BI reports and handling numerical data with multiple hierarchies, the Matrix visual is often the go-to choice. It seamlessly accommodates hierarchical data with proper modeling, allowing the use of measures as rows. However, what if you need to display measures as rows with specified indentations, sorting, and font […]

Read more

Add custom fonts in SSRS Report

, February 13, 2024222 Views

Adding  custom fonts in SSRS or SQL Server Reporting Services is a powerful way to personalize and enhance the visual appeal of your reports. This process involves selecting a distinct typeface that aligns with your brand identity and integrating it seamlessly into your SSRS environment. Let’s explore how the addition of a custom font can […]

Read more

Would you like to digitize your business and put it on the cloud?
Do you need clear, concise reports for your organization?