If you want to become an Power BI expert, check out all our helpful tutorials on Microsoft Power BI. All the tutorials are written by experts and followed steps properly and written with screenshots. You can email us if you still have questions for us.
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 >>>
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 >>>
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 >>>
Free guide
A practical, step-by-step blueprint to build a project management system in SharePoint Online. Tell me where to send it.
Your free SharePoint Project Management Guide is on its way. Can't find it in a few minutes? Look in your Promotions or Spam folder.
Sent to
