The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |