Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
thomas_coltrain
Frequent Visitor

Multiple Fields in the rows of a report

 Hey,

So I am having an issue trying to get 2 different document types in the same report.  I have tried in the regular table and matrix of getting posted sales invoices and posted sales credits(business central) in the same report.  Every time I try to do this the info gets messed up and fields do not report the correct data.  Is there any way to have the documents separated in the same report or does anyone have a suggestion on this?  This information can not be combined/merged in the same field data

Example of what I am looking for (all of this in the same report), let me know if more info is needed

 

Doc #                                   Header info here/Values here

PSI-0001              x         x           x

PSI-0002              x         x           x

--------------------------------

Doc                                       Header info here/Values here

PSC-0001             x         x           x

PSC-0002             x         x           x

1 REPLY 1
amitchandak
Super User
Super User

@thomas_coltrain , I doubt this is possible with standard visual.

For this small multiple support is needed for table and matrix. You can log an idea for that.

 

You can check for the custom visual or paginated reports (premium customer feature)

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.