Skip to main content

Power BI

New

Matrix Upwards Expansion

Vote (14) Share
Vojtech Sima's profile image

Vojtech Sima on 14 Dec 2023 22:07:19

Allow users to check whether they want the expansion in Matrix to go Up or Down.

Comments (1)
Vojtech Sima's profile image Profile Picture

Thomas Meyer on 27 Mar 2024 14:11:11

RE: Matrix Upwards Expansion

This is frequently needed.Say, you have a matrix view with a hiearchy resembling a multi-level invoice:Invoice RG-1234:1000 screws: 10 Euro500 nails: +5 Euro200 connectors: +50 EuroSum Materials: =155 Euro2h workhours +100 Euro1h installation +50 EuroSum Personell: =150 EuroWaste disposal +50 EuroCleaning fee +50 Eurocall-out charge +50 Europromo rebate -50 EuroSum fixed costs: =100 EuroNet amount: =405 Euro+20% VAT +81 EuroGross amount: =486 EuroObviously, there is a hierarchy with totals and sub-totals. However, you need to open the children on top of the parent level, not below.Currently, this is not possible in Power BI.