How to get custom columns and values together in a table

[mp390988]

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.

Thanks,

[andrewsommer · Accepted solution]

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:

 

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

[mp390988]

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?

[andrewsommer · Accepted solution]

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

[mp390988]

@andrewsommer  - thank you, that works!

[mp390988]

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.

[andrewsommer · Accepted solution]

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:

 

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

[mp390988]

Hi @andrewsommer,

This is helpful 🙂

Thank you so much.

[andrewsommer]

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

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