Have you ever tried to sort column headers in a Power BI matrix visual? There is no sort option available in the Matrix visual to sort the column headers, like row sorting. While researching this, I discovered that there was no clear explanation in one place. I thought I would share my experience in this … Read more >>>
Have you ever tried applying conditional formatting to your Power BI Matrix visual? That makes your data more engaging and easier to understand. You can add background colors, font colors, data bars, icons, or web links to your matrix visualization to highlight the data. In this tutorial, I will explain how to apply conditional formatting … Read more >>>
In this tutorial, I have explained the problem I encountered when trying to turn off the stepped layout option, which displays data in a Power BI matrix visual without any steps similar to Excel. The issue I faced: In the latest version of Power BI Desktop, I have created a matrix visual. I added multiple … Read more >>>
Do you want to learn how to use a matrix visual in Power BI? I will help you with some Power BI matrix examples. In this Power BI tutorial, I will explain Power BI Matrix visualization. Along with this, I will also cover some more topics mentioned below: What is a Matrix Visual in Power … Read more >>>
For a few days, I have been working on the Replace() function in Power Automate, which allows replacing characters in a string, substrings within a string, strings within an array, and strings within a JSON array, as well as multiple objects within an array. This tutorial explains how to replace the last character of a … Read more >>>
One of our clients contacted us regarding a requirement where they had an Excel file containing project details and associated company information for 2025, which is stored on their local desktop. The requirement is to replace one of the Associated Company names in the Excel sheet, as it has recently changed its name. We can achieve … Read more >>>
Are you trying to replace newlines in a string with <br> tags using Power Automate? Unfortunately, Power Automate does not allow you to process new line characters using the replace function, which is a non-printable character. When trying to replace the ‘\n’, which represents a new line, the replace function will consider it as a … Read more >>>
A few days ago, I worked on a flow that required creating multiple SharePoint lists and libraries automatically from a single JSON file. Instead of creating each one manually, I used Power Automate to read the JSON and create the SharePoint lists. In this Power Automate tutorial, I will show you how to create SharePoint … Read more >>>
In this tutorial, I will explain how to work with the CAML query builder for SharePoint. This tool will help you build CAML queries to efficiently query lists and libraries. We will learn how to download and install the CAML query builder for SharePoint, as well as how to utilize it within SharePoint. Before understanding … Read more >>>
If you are working as a SharePoint administrator, then you might need to check the SharePoint version for troubleshooting, patching, and ensuring compatibility with solutions or features. In this tutorial, I will explain how to check the SharePoint version using PowerShell. Check SharePoint On-Premises Version with PowerShell SharePoint on-premises (e.g., SharePoint 2013, 2016, 2019) stores … Read more >>>
Join this free live session and learn how to build a Quiz application using SharePoint Framework (SPFx).
📅 2nd June 2026 – 10:00 AM EST | 7:30 PM IST
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App
Download 135 Pages FREE PDF on Microsoft Power Platform Tutorial. Learn Now…