Bijay Kumar 
Recently, I was working on building a SharePoint Online site page that required displaying an Excel spreadsheet, allowing employees to view the data directly on the page rather than navigating to the document library and opening it. After researching, I found two different web parts for displaying an Excel spreadsheet on a SharePoint site page: … Read more >>>
I have created a Power BI report based on ‘Product Sales Information‘ for one client, utilizing various types of visualizations. On that report, the client instructed me to display the average sales amount of products in the matrix visual. However, by default, the matrix visual displays a sum aggregation of the values, showing the total … Read more >>>
When you create a new SharePoint list, a Title column appears by default. In many cases, this column doesn’t match your actual data structure, especially if you’re using fields like Project Name, Task, or Customer ID. In this type of case, we need to rename the title column in the SharePoint Online list. In this … Read more >>>
Recently, a client asked me to create a Power BI report where the Matrix visual should display multiple rows without using a hierarchical format. Instead of nested rows, they wanted a flat, tabular look where all row fields appear independently, side by side. To achieve this, we need to remove the hierarchy in the Matrix … Read more >>>
Recently, I built a Power BI report for one of our clients that has Matrix Visualization. He asked me not to show the ‘subtotals’ values of the column, but he wanted me to display the grand total value of the column in the matrix. I achieved this by turning off the “Show subtotals” option for … Read more >>>
Would you like to learn how to adjust the column width of a Matrix visual in Power BI? I will help you to do that for your Matrix visual in your Power BI report. Power BI Desktop has an “auto-size column width” feature that automatically resizes the width of the Power BI matrix column depending … Read more >>>
In a Power BI Matrix visual, we can sort column values in alphabetical order. Very useful for different clients. A few days ago, one of our clients asked me to design a Power BI report that includes a Matrix visual. The Matrix displays the ‘Products’ in a random order, whereas they wanted the values to be … Read more >>>
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 >>>
Learn how to build an intelligent invoice processing solution using:
Learn how to build a real-world Invoice Management System using a SharePoint Integration Power Apps Form with a repeating table—supporting multiple invoice line items.
📅 2nd September 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…
