Forum Discussion
Post PartisanMatrix Visualisation collapse expand and calculations
I have 3 tables-
1) Stock Due
2) Past Sales
3) Stock On Hand
and I need the Output as Below-
The highlighted Total Stock Due and Average of past 6 months Sales needs to be having expand/collapse functionality. So if expanded then the data could be seen month wise.
And everything needs to be in $ value so whever the qty is, there the calculation will be Qty* Avg Cost.
I tried to do, but I am unable to do in matrix form.
It is Range-wise summary but items (A B C D E F G) can come underneath range but only when ethe range is clicked, otherwise need to have the summary by range as the main visual.
1 Reply
Hi learner03 ,
Could you please provide these sample data with Text format (paste the data in your post directly) and the calculation logic of getting the [Total Stock Due] and [Average of past 6 months Sales] base on your shared sample data? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
In addition, please review the following links about expanding or collapse the matrix. Hope they can help you.
Expand/Collapse Matrix ColumnsThe fields can be expanded only when there is a hierarchy in the data. The hierarchy between columns does not exist and only exists between rows.
Expand/collapse column hierarchy in Power BI
Power BI Collapse & Expand Measures using Slicer | Hide and Unhide Measures in Matrix
Best Regards
