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 hide the column headers in the Power BI matrix visual. Currently, the option to disable column headers in a matrix is not available. There is no actual solution to this.
As a workaround for this, we can only format the column headers by changing the Font color of the headers that match the background color.
This tutorial will show you two workarounds on how to hide the Matrix column headers in Power BI.
- Formatting the Font color of the Column Header in Power BI
- Masking the Power BI Matrix Column Headers with a Layer
Hide Column Headers in Power BI Matrix
In this section, let me show you how to hide the column headers in the Power BI matrix visual.
This workaround hides the column headers in a matrix visual, but it only supports hiding all column headers at once, not selectively.
From the following screenshot, you can see the Matrix visual displaying products by year, with quantity as values.
Here, you can see the column headers, highlighted in the image below.
See: How to Create a Matrix Visual in Power BI
Workaround 1: Formatting the Font color of the Column Header in Power BI
Now, I wanted to hide the column headers present in the highlighted area, as shown in the matrix table above.
Quick steps to follow:
- On the Power BI desktop, select the Matrix. Go to the Visualizations pane and click on Format your visual icon.
- Expand Column headers. Set the Text color to match the Background color.
Then, this will make the text color the same as the background color, which makes them hidden in the matrix table.
Output:
If you don’t want to hide the entire column headers in the Matrix visual, there is an alternative workaround to achieve this.
Workaround 2: Masking the Power BI Matrix Column Headers with a Layer
In this workaround, you have to mask the column headers in the Matrix with a layer. Follow the steps mentioned.
Suppose you have a Matrix visual similar to the one below, where you only want to hide the ‘Category‘ and ‘Product‘ parts.
Check out the steps below to achieve the requirement mentioned above:
- On the Power BI Desktop report canvas page, click on the Insert tab.
- Then, click on the drop-down menu of shapes and select “Rectangle.”
- From the Format pane, click on Style, fill the color to ‘White‘.
- Resize the shape and put it over the column header.
These are the methods for hiding column headers in the Power BI Matrix visual.
I will also suggest that you vote for the ‘Remove matrix column headers’ option in the Power BI Idea community.
If you have any suggestions, please share them in the comment section below.
You may also like the following Power BI Matrix visual tutorials:
- Turn Off Grand Totals in Power BI Matrix
- Set Column Width in Power BI Matrix Visual
- Sort Column Values in Matrix Visual Power BI
- Power BI Matrix Visual Conditional Formatting
After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.
