Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
On the matrix visual, I want to show sales history by month and to only show quantity on hand, and forecast quantity once.
Currently, in the Matrix it shows quantity on hand and sales history by month.
How can I acheive this?
Here's how it will look:
Item Code | Item Description | January 2020 | February 2020 | March 2020 | April 2020 | May 2020 | June 2020 | July 2020 | August 2020 | September 2020 | October 2020 | November 2020 | December 2020 | Summarized Sales (Total) | Quantity on Hand | Forecast Quantity |
123-ABC | Samp | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 5 | 13 | 3 | 2 |
I was able to put Quantity on Hand column from the data table to the "Row" in the Matrix visual, but it shows up in the beginning. I want to be able to order it differently.
Hi @PBIUWO
Could you show me a sample like the table you are dealing with by your OneDrive for Business?
Please show me your calculate logic about how to get the forecast Quantity.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@PBIUWO , seem like you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |