Calculate Percentage of Total in Power BI Matrix

Percentage of Total in Power BI Matrix

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 >>>

Display Average Instead of Total in Power BI Matrix Visual

Show Average Instead of Total in Matrix Power BI

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 >>>

Hide or Remove Column Headers on Power BI Matrix Visual

Hide matrix column headers Power BI

A few days ago, I worked on a Power BI report for one of our clients, utilizing various visualizations based on sales data. The requirement was to display a specific part of the column headers in the Matrix visual by hiding the other parts in that report. Unfortunately, there is no such functionality available to … Read more >>>

Display Multiple Rows in Matrix Without Hierarchy in Power BI

Power BI matrix multiple rows without hierarchy

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 >>>

How to Set Column Width in Power BI Matrix Visual?

Set Fixed Column Width in a Power BI Matrix Visual

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 >>>

How to Sort Column Values in Matrix Visual Power BI?

Power bi sort columns in matrix descending

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 >>>

How to Sort Matrix Column Headers in Power BI?

Matrix Table Column Header Custom Sorting

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 >>>

Power BI Matrix Visual Conditional Formatting

Power BI Matrix Visual Conditional Formatting

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 >>>

>

Build a High-Performance Project Management Site in SharePoint Online

User registration Power Apps canvas app

DOWNLOAD USER REGISTRATION POWER APPS CANVAS APP

Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App

Power Platform Tutorial FREE PDF Download

FREE Power Platform Tutorial PDF

Download 135 Pages FREE PDF on Microsoft Power Platform Tutorial. Learn Now…