Recently, I was working on a Power BI matrix visual for a client. They wanted to calculate the percentage of the total in the Matrix visual. The client had sales data for various products like laptops, keyboards, mouse, and monitors. They wanted a Power BI report that not only showed the sales values but also … Read more >>>
One of my colleagues was working on a Power BI report, where some of the values in his matrix visual were showing up as blank. From a user’s point of view, blank cells can be confusing. So, we needed to show zero instead of blank in the matrix visual. In this Power BI tutorial, I’ll … Read more >>>
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 >>>
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…
