Group Metrics to Display Vertically

[nj-matt]

So I have a dataset that looks something like this -

Product	Plan Gross Sales	Plan Net Sales	Plan Profit	Quota Gross Sales	Quota Net Sales	Quota Profit	YAGO Gross Sales	YAGO Net Sales	YAGO Profit
Brand A	120	80	40	115	80	45	100	75	45

I would like to group metrics and display in a visual like this -

Brand A	Plan	Quota	Yago
Gross Sales	120	115	100
Net Sales	80	80	75
Profit	40	45	45

How can I do this?

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[v-jayw-msft · Accepted solution]

Hi @nj-matt ,

Check the following steps in Query editor.

1# Select Product column use Unpivot other columns feature.

2# Add two custom columns as below.

3# Create the visual.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[amitchandak]

@nj-matt , refer if this can help

https://kohera.be/blog/power-bi/how-to-unpivot-twice/