How to Put Attribute below Measure in a Column

[aritaa01]

Hi, 

I Have a Table as show below

I need to move category Product below Measure. and the result should be like this table:

What should i do to Create those Visual Table in Power BI.

Thanks
Regards

andri

[johnyip]

To display your data like this, you have to use a matrix, but the underlying data you are using must follow the correct structure, like the following.

Type	Channel	Product	Sales	Return	Discount
Sales Value	Modern Trade	Product A	1000
Return	Modern Trade	Product A		200
Discount	Modern Trade	Product A			50
Sales Value	Modern Trade	Product B	8000
Return	Modern Trade	Product B		100
Discount	Modern Trade	Product B			200
Sales Value	Retail	Product A	2000
Return	Retail	Product A		300
Discount	Retail	Product A			150
Sales Value	Retail	Product B	7000
Return	Retail	Product B		200
Discount	Retail	Product B			100
Sales Value	Second Dealer	Product A	3500
Return	Second Dealer	Product A		300
Discount	Second Dealer	Product A			100
Sales Value	Second Dealer	Product B	5000
Return	Second Dealer	Product B		300
Discount	Second Dealer	Product B			150

And then, create measures to capture the sales / return / discounts of your data.

[aritaa01]

So Basically i should unpivot the Table. there is no other ways, due to the data much bigger

[johnyip]

Yes, i believe this is the only way, unless there are some other custom visuals that are capable of displaying the data in your required format.

[Mid_anderson]

You can try to make a new column to your category product, something like this: product, channel, sales value, return, discount 

[aritaa01]

Hi @Mid_anderson 
For my case the category have a hierarcy level, as Sample for Segment/ Sub Segment
Product A Segment : Book, Pen
Product B Segment: Milk, Yogurt
and it will have a lot of segment/ sub segment product

any others advice for this?