Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have this data table:
Member | Date | Fund | Adjust | TotalExp |
Member1 | 1/25/2022 | 50.1 | 12.45 | -102.8 |
Member1 | 2/6/2022 | 52.4 | 10.8 | -35.6 |
Member1 | 3/25/2022 | 80.5 | 15.4 | -40.5 |
Member2 | 1/8/2022 | 52.4 | 10.8 | -35.6 |
Member2 | 2/14/2022 | 65.9 | 22.8 | -63.4 |
Member3 | 6/1/2022 | 96.5 | 25.4 | -58.4 |
Member3 | 3/25/2022 | 84.6 | 15.7 | -57.6 |
I have in a table visual the following output:
Row Labels | Member | Sum of TotalExp | Sum of Adjust | Sum of Fund |
Jan | 2 | -138.4 | 23.25 | 102.5 |
Feb | 2 | -99 | 33.6 | 118.3 |
Mar | 2 | -98.1 | 31.1 | 165.1 |
Jun | 1 | -58.4 | 25.4 | 96.5 |
Grand Total | 3 | -393.9 | 113.35 | 482.4 |
However, I need the output in this way:
Values | Jan | Feb | Mar | Jun | Grand Total |
Distinct Count of Member | 2 | 2 | 2 | 1 | 3 |
Sum of TotalExp | -138.4 | -99 | -98.1 | -58.4 | -393.9 |
Sum of Adjust | 23.25 | 33.6 | 31.1 | 25.4 | 113.35 |
Sum of Fund | 102.5 | 118.3 | 165.1 | 96.5 | 482.4 |
I have try unsuccessfully with the matrix data, I tried unpivot columns, but not getting the desired result. Please, any help?
Thanks
Solved! Go to Solution.
Add measures to the Values field well of a matrix:
In the Format pane, go to Values and enable "Switch values to rows":
Result:
Proud to be a Super User!
Add measures to the Values field well of a matrix:
In the Format pane, go to Values and enable "Switch values to rows":
Result:
Proud to be a Super User!
Wow @DataInsights , exactly what I need. Really I have about three months working with BI, but your solution seems so ease now and I didn't find the way, that's why there are superuser like you. Thank you so much for your help.
Glad to hear that works. These forums are a great place to learn, and there's always something new to add to your toolkit. 🙂
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |