Is this kind of tabular report possible in Power BI?

[ciarano]

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.

[v-ljerr-msft]

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