Table with grouped rows

[Anonymous]

Hello,

I'm trying to replicate this table:

And this how the data is in the table:

We have multiple objectives and the idea is to group them but show their KPIs in different rows next to them, is there any way to repliacate that?

TIA

[Greg_Deckler]

@Anonymous The first image looks like a matrix with row stepped layout turned off. Overall it's hard to tell from the images exactly what you need. Sample data as text?

[Anonymous]

Oh sorry, I'll give more detail.

This is how the data (shortened) is in the Excel (keep in mind, we are open to modifying the Excel file in order to get the data visualized better):

OBJECTIVES	KPI	Metric	Definition	Weight
A	KPI1	USDm	Margin 1	8%
A	KPI2	%	Margin 2	7%
A	KPI3	%	Annual Example 1	6%
A	KPI4	USDm	Revenue excl.	4%
B	KPI5	USDm	Revenue excl. IFRIC12	2%
B	KPI6	Score	NPS	3%
B	KPI7	Index	Cust Serv Indicator	5%
C	KPI8	Index	Security Indicator	4%
C	KPI9	$/move	Unit cost 1	8%
C	KPI9	$/ton	Unit cost 2	5%

And this is how we'd like it to look with the sample data:

Like you see, the difference between how the data is stored to how is it shown is to group those objectives and KPIs that are the same (we could let go the grouped KPIs).

Is this enough or do you need more info?

TIA

[v-deddai1-msft]

Hi @Anonymous ,

Not very clear what is your expected ouput. Would you please show us the expected output by your sample data? And does the screenshot below meet your requirement?

Best Regards,

Dedmon Dai

[Anonymous]

Hello @v-deddai1-msft,

Oh I just saw it, the image I put as the expected output wasn't loaded or shown, that was unfortunate.

But yes, the screenshot you posted would be the expected output, the grouping of similar values in objectives and (if possible) in KPIs. Can I ask how did you do it? 

TIA

[v-deddai1-msft · Accepted solution]

Hi @Anonymous , 

Use matrix in power bi, Put objectives and KPI in Rows,

Close the stepped layout in row header:

You can refer to https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/ for using of matrix.

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

Best Regards,

Dedmon Dai