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.
Hi all,
I'm having trouble creating one matrix visual with all the data come from one table behind.
Now, I'm able to visualize with Format--> Edit Interactions and applying two slicers in two matrices. Since we need to know Increase Qty and Decrease Qty the data table is filtered and aggregated by SUMX and FILTER functions in a measure like:
IncreaseQty = SUMX(FILTER('Data Table', 'Data Table'[Entry Type]="Increase"),'Data Table'[QTY])
When I add the sum of Starting Qty to the Values of the Matrix including IncreaseQty I got numbers that I don't look for 😕
However in the final visualization the Start of Period Qty, Increase Qty, Decrease Qty, End of Period Qty are supposed to be in one visual.
Could you please send your thoughts how to make it only in one table/matrix visual.
______________________________________
I have data similar to this:
DATE | INVENTORY GROUP | ITEM No. | DESCRIPTION | ENTRY TYPE | QTY |
2022-12-31 | GOODS | Barley-22 | Barley | Increase | 4 |
2023-01-06 | GOODS | Barley-22 | Barley | Increase | 8 |
2023-01-07 | GOODS | Barley-22 | Barley | Decrease | 15 |
2022-12-31 | GOODS | Corn-21 | Corn | Increase | 15 |
2022-12-31 | GOODS | Corn-22 | Corn | Increase | 32 |
2023-01-01 | GOODS | Corn-22 | Corn | Decrease | 5 |
2023-01-08 | GOODS | Corn-21 | Corn | Decrease | 8 |
2023-01-10 | GOODS | Corn-22 | Corn | Increase | 10 |
2022-12-31 | GOODS | Soy-22 | Soy | Increase | 4 |
I want sg like this:
INVENTORY GROUP | 2022-12-31 | 2023-01-13 | |||
Item No. | Description | Start of Period Qty | Increase Qty | Decrease Qty | End of Period Qty |
Hi im not 100% clear on what you are trying to do but this option might help you?
Thank you! I haven't used that option so far. However we didn't get closer now.
To make clear I'm trying to use two slicers on one dataset in a table/matrix visual while some colums in the visual are filtered.
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |