Recently, I worked on a Power Automate flow that required sending a report to a manager on a monthly basis. The report should only include items with the status “New” from a SharePoint list. To do this, I used the Filter Array action in Power Automate. The Filter Array action in Power Automate is particularly … Read more >>>
In this tutorial, I have explained the issue I faced when trying to display all the values in the Matrix visual that I wanted to show in my Power BI report. The Issue is: I have created a Matrix visual where I added data to the Rows, Columns, and Values. When I place a text … Read more >>>
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 >>>
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…
