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.
Does anyone know if this kind of tabular report is possible in Power BI (see image below)?
Each pair of report lines comes from 1 row in the database but I need it to display as 2 rows in the table. I also need to group the data by the Deal No and display in-table totals for the Market Value.
i.e. the data for the 1st row would be:
Deal No: 8598, Counterparty: Counterparty1.....RecPay1: REC, RecPay2: PAY, MarketValue1:2,296.99, MarketValue2:-12,108.94
etc.
Not sure if I can do this in Power BI or if I should be doing this in something like Crystal Reports.
Hi @ciarano,
I don't think it is possible to do it in a Table/Matrix visual in Power BI currently. You can submit your requirements on Power BI Ideas to improve the flexibility for Table/Matrix visual in Power BI.
Regards
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |