Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
mp390988
Helper V
Helper V

How to get custom columns and values together in a table

Hi,

I need to create the below table in power bi.

I can create the measures without any issues.

But the issue I am having is presenting my data in the table format exactly like below.

Like, how does one go about creating custom row labels like "Annual Target", "YTD", Revenue to achieve target", "Trading Days", "Required Run Rate" and making the right measures appear next to them?

I really need to know how to do this as this is just one example of this particular scenario.

 

mp390988_0-1754074485288.png

 

Thanks,

 

2 ACCEPTED SOLUTIONS

You put the measures you created in the value section of the matrix visual. If you need to change the name of the measure for the visual, you can do it in the pill in the values section:

andrewsommer_0-1754075764433.png

 

 

Please mark this post as a solution if i t helps you. Appreciate Kudos.

 

 

 

View solution in original post

Since it's the header the easiest way would be to just layer a text box or card visual over it and put in whatever you want

View solution in original post

7 REPLIES 7
mp390988
Helper V
Helper V

Sorry, I forgot to ask one more thing, how can I add header/some text in the section I boxed in red in the visual below?

mp390988_0-1754083737150.png

 

Since it's the header the easiest way would be to just layer a text box or card visual over it and put in whatever you want

@andrewsommer  - thank you, that works!

mp390988
Helper V
Helper V

That doesn't help at all.

Where do I input custom row names, how do I assign the right measures to my row names so that when I display it, the right row has the right measure next to it.

You put the measures you created in the value section of the matrix visual. If you need to change the name of the measure for the visual, you can do it in the pill in the values section:

andrewsommer_0-1754075764433.png

 

 

Please mark this post as a solution if i t helps you. Appreciate Kudos.

 

 

 

Hi @andrewsommer,

This is helpful 🙂

Thank you so much.

andrewsommer
Super User
Super User

Use a Matrix visual and then in formatting go to Values > Options > Switch values to rows and toggle on

andrewsommer_0-1754074983509.png

 

Please mark this post as a solution if it helps you. Appreciate Kudos.

 

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.