cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jeffgarlisch Regular Visitor
Regular Visitor

Matrix Column Headers not showing name of values

Hey All, 

 

I'm working with a matrix like so, a single financial value, sum by  monthyear(columns) and Institution(Rows), but as you can see it is not displaying the name of the column being pulled for the financial value sum. 

 

Capture1.JPG

But when i put in a second column to the values section of the matrix it displays both names

 

 

2018-12-06 08_01_28-Clipboard.png

 

Is there any way t get it to display the name of the column used for the value summation when there is only one column chosen?

 

 

This is the end result im looking for:                                                                          

Capture3.JPGRequired End Result

                                                       

 

 

 

                                                     

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Matrix Column Headers not showing name of values

Hi @jeffgarlisch,

 

Currently it is not possible to meet your requirement. There is an idea that can work on your request, you can vote it up. I have help to vote it already Smiley Happy

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35849152-matrix-hide-column-and-s...

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Jeltex Member
Member

Re: Matrix Column Headers not showing name of values

Hi @jeffgarlisch,

 

You can double click on "value 1" or "value 2" and rename it to whatever you want.

 

Kind Regards,

Jelte

jeffgarlisch Regular Visitor
Regular Visitor

Re: Matrix Column Headers not showing name of values

I understand how to rename the column headers, as I already renamed them to value 1 & value 2 for my example.

 

What im asking is if there is a way to make the matrix display the name "Value 1" as a secondary column header like so, when it is the only value reference in the Values box of the matrix structure menu, on the right hand side of the page.

 

I need my matrix to look like this. Is it possible?

Capture3.JPG

 

 

 

Jeltex Member
Member

Re: Matrix Column Headers not showing name of values

You can "Trick" PowerBI in creating a customn column with only "Value 1" in it.

You would then place that customn column under columns and then expand 1 level down.

 

This will result in the following:

Capture.PNG

I think this is as close as you can get.

Community Support Team
Community Support Team

Re: Matrix Column Headers not showing name of values

Hi @jeffgarlisch,

 

Currently it is not possible to meet your requirement. There is an idea that can work on your request, you can vote it up. I have help to vote it already Smiley Happy

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35849152-matrix-hide-column-and-s...

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Community Support Team
Community Support Team

Re: Matrix Column Headers not showing name of values

Hi @jeffgarlisch,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case.


Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 522 members 4,288 guests
Please welcome our newest community members: