Double column header rows in matrix

[Anonymous]

Hi

I have a matrix where I present a couple of measures as values (e.g one measure for actuals 2021, one measure for actuals 2020 etc.). I would like to group the values with double rows for the headings.

Currently I have the set up in the top of the picture below but I want to acheive the set up in the buttom of the picture.

Any ideas? Is possible to include a line break under "rename for this visual"?

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[Anonymous]

Thanks for the answer.

I understand your solution but it is not possible to change the model as you suggest.

I would really need to create some kind of "grouping" for my measures

[Anonymous]

Hi @Anonymous 

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function：Group measures in Matrix

Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Rico Zhou

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

[Anonymous]

Hi @Anonymous 

Currently, you build two measures one called MTD-2021,another called MTD-2020 and add them into value field in Matrix.

If you want to show your result as the screenshot as below, it is better for you to change your data model.

MTD in First column 2021,2020 in second column named Year column, and third column named value.

Then build a measure for MTD by Value column. Build Matrix as below.

Best Regards,

Rico Zhou

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

[Nathaniel_C]

Hi @Anonymous ,
I solved something similiar by putting a text box over the top of the matrix with - in your case -MTD and the appropriate background, and then in format creating the two as a group.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[Anonymous]

I have tried that but it does not look good enough

I was wondering if you could do something with the ISSELECREDMEASURE function but I dont get it to work