Anmol Power BI Corner

  How to Use Multi-Cursor in Power BI TMDL View Microsoft recently introduced the TMDL (Tabular Model Definition Language) View in Power BI Desktop, and one of its most exciting features is multi-cursor support . Steps to Enable and Use Multi-Cursor in TMDL View: Enable TMDL View Go to File → Options and Settings → Options Under Preview Features , enable TMDL View and restart Power BI Desktop. Navigate to TMDL View Open any Power BI model and switch to TMDL View . Use Multi-Cursor Feature Click on a blank space where you want the first cursor. Press and hold Alt and click on another space to add a second cursor. Repeat the process to add multiple cursors for simultaneous editing. This feature enhances efficiency, allowing you to edit multiple lines at once, similar to multi-cursor support in code editors like VS Code. If you want to know more then feel free to reach out to me on LinkedIn . For detailed video, Check AnmolPowerBICorner youtube channel.

  In this guide, we’ll cover how to bring task data from Microsoft Planner into Power BI for analysis, using Power Automate and SharePoint as intermediaries. Since Power BI currently lacks a direct Planner connector, Power Automate lets us fetch the data from Planner and save it to SharePoint as a JSON file, enabling Power BI to access it on a scheduled basis. Prerequisites Before you begin, ensure you have: Access to Microsoft Planner  – to view and retrieve Planner task data. Power Automate License  – access to create and run Power Automate flows. SharePoint Access  – a SharePoint site to store JSON files. Using SharePoint simplifies the setup, as it doesn’t require a premium Power BI or Power Automate license. Power BI Desktop  – to set up and configure the JSON data connection and publish the report. Microsoft 365 Account  – for authentication, as we’ll be connecting Power BI to SharePoint through your organization’s Microsoft 365 credentials. Step 1: S...

  In this blog, we'll explore how to display the previous 6 months of data based on a single slicer selection in Power BI. Data Model Overview To achieve this, we create two relationships between the ‘Date’ table and the ‘Sales’ table. The active relationship uses order data, while the inactive relationship uses delivery data, as shown below:   Data Model Configuration:  We have configured the relationships so that the active relationship filters based on order data, and the inactive relationship filters based on delivery data. The Challenge The challenge is to figure out how to display data for different months using a slicer. In our case, the Year and Month slicer is based on the ‘Date’ table and is currently filtering only the selected months. This is fine for typical month-to-month selection, but we want to display the previous 6 months based on the selected month. The Solution To solve this, we will create an additional table that will contain the same month values a...

  What is the Data Limit Feature? The  Data Limit  feature enables users to define a maximum threshold for the amount of data loaded into a Power BI report. This is particularly useful when working with extensive datasets, as it helps prevent performance bottlenecks and prioritizes the most relevant data for analysis. By setting a data limit, users can streamline their reporting processes and focus on critical data points.   Why is the Data Limit Feature Important? Handling large datasets can lead to challenges such as slow report performance, lengthy load times, or even system crashes. The  Data Limit  feature addresses these issues by allowing you to: Prevent your system from being overwhelmed. Streamline the data analysis process. Focus on the most essential data.   How Does the Data Limit Feature Work? Example: Sales Data Table Imagine a sales dataset for an entire year with columns like date, product name, sales amount, and region. Here’s what you...

Data Labels are one of the critical components of any  Power BI  visual. It allows users to understand the visuals easily. With the help of Custom Data Labels, users can see a particular data point and trends.   In this blog, we will see how to add custom Data Labels in bar and column charts.   Step 1: Select the chart where you want to add custom data labels.   Step 2: Go to Formatting > Data Labels > Values > Enable Custom Label.   You can add any measure or values to the Custom label. It accepts only one field, so you cannot add multiple fields. In case you want to show multiple fields, then you can create a measure to concatenate them first and then use it.   You can also format the label as per the requirement.   Regards  Anmol Malviya Data Analyst |  Addend Analytics

  DAX functions are thriving nowadays, they have become one of the most popular and learned languages in the Business Intelligence Domain. It contains expressions that are a kind of magical in themselves and help in analysis for finding useful insights. This blog is all about providing an overview of most commonly used expressions in Power BI which are ALL, ALL SELECTED and ALL EXCEPT.   ALL – Returns all the rows in a table or all the values in a column, ignoring any filters which might have been applied. Syntax- ALL ([<TableNameOrColumnName>] [, <ColumnName> [, <ColumnName> [, …]]]     This syntax will help us to get a total of sales value while ignoring any filters which might have been applied on the product name. In the image shown below we have a measure named as “ALL” present in the table which is providing a total of sales value without getting affecting through the product name column present in the table, as we have used the “ALL” function...

  In this blog, we’ll explore two straightforward methods to connect Excel files to Power BI and learn how to append multiple similar Excel files dynamically, saving time and effort.   Blog Structure   1. Connect to Excel in Power BI Using the Excel connector Using the Folder connector 2. Combine Similar Excel Files into a Single Table Dynamically   Connect to Excel using Excel connector: Step 1:  Either select ‘Excel’ in Home ribbon or click on ‘Get data’ & select ‘Excel’. Step 2:  A browse window will pop up. Navigate to the Excel file’s location. Click on the file & select ‘Open’. Step 3:  In the ‘Navigator’ window, select the required sheets & click ‘Load’. Clicking on Transform data will take you to the Power Query Editor.     Step 4:  Apply transformations of your choice & then choose ‘Close & apply’. Your data will be ready to visualize.   Connect to Excel using Folder: Step 1:  Click on ‘Get data’ ...