Inkey Solution Logo


Power BI Consulting: Switching between Aggregated Value and Break downed values using Field Parameters

, April 12, 2024351 Views

Switching between aggregated values and breakdown values using Field Parameters in Microsoft Power BI allows users the flexibility to choose between viewing the total amount for all categories, such as products or regions, or breaking down the amount values by specific categories. This capability through Microsoft Power BI Consulting empowers users to view aggregated sales […]

Read more

Microsoft Power BI Consulting: How to get the data from the outlook attachment and load it to the Power BI report

, April 5, 2024408 Views

In the dynamic realm of data analytics and Microsoft Power BI Consulting, incorporating Excel files into Microsoft Power BI reports is a common practice. Often, these files are received as email attachments in Outlook, requiring a manual download and integration process. While this approach is functional, it poses challenges when it comes to maintaining an […]

Read more

Introducing Explore this data feature in PowerBI service

, April 2, 2024269 Views

In Power BI, users often find the need for spontaneous exploration of their data, particularly when gaining access to a new semantic model or data source. Whether it’s an analyst seeking to familiarize themselves with the dataset or a business user with a specific question requiring immediate answers for a presentation, the conventional approach of […]

Read more

Creating the Linear Gauge to Check the Status of Sales in Power BI

, March 29, 2024238 Views

Microsoft Power BI offers an extensive range of charts and graphs designed to visually represent data, facilitating insightful analysis for making informed business decisions. Occasionally, stakeholders prefer a broad overview of their performance and target achievements, categorized into percentage ranges, without delving into precise figures. While Power BI lacks a built-in linear gauge visual akin […]

Read more

Enhancements in Column, Bar and Ribbon Charts in Power BI

, March 26, 2024275 Views

Microsoft Power BI continues to be a cornerstone in the BI community, with its relentless commitment to updates catering to evolving business needs. The latest eagerly awaited enhancements in Column, Bar, and Ribbon Charts provide users unparalleled flexibility to tailor their visualizations. Enhancement in Stacked Column/Bar Charts: In recent updates we get the following options […]

Read more

Implementing ADF Branches and Filters for Employee Training

, March 22, 2024275 Views

In one organization, there is one analysis of employee’s performance on different technologies based on the technologies they know and ratings from their manager. If they don’t meet the required criteria, then that employee will get training for those technologies. Input: emp_id MSBI PowerBI ratings from the manager 101 null x 3 101 null null […]

Read more

Enhancements in the New Card Visual in Power BI

, March 19, 2024276 Views

Microsoft is always keen to bring new updates to its reporting service Power BI. Because, it has a wide user base and makes it easy for the report viewers and data analysts to easily dive into their data and analyze it. This also makes the report developers happy because they find it easy to show […]

Read more

Revolutionizing DAX with the Magic of Visual Calculation in Power BI

, March 15, 2024384 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, 2024312 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, 2024305 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

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