Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
So Basically i should unpivot the Table. there is no other ways, due to the data much bigger
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.
You can try to make a new column to your category product, something like this: product, channel, sales value, return, discount
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?
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |