I need this specific report layout. Is this possible in Power BI?

[esther21179]

Hello,

I am trying to create this specific report layout. Please don't just look at it and tell me it is a simple table. It is not. One whole block contains all the information for one gift. It is a non-Excel type data layout, where the user can see everything at one time rather than scrolling over to the far-right in a table. 

Is this possible in Power BI? I can't find any visuals that will do this. 

Thanks,

Esther

[Anonymous · Accepted solution]

Hi @esther21179 ,

It requires the report be put in the workspace where is in a Premium capacity when the paginated report is published to Power BI service. You can find more details in the following documentations.

Publish a paginated report to the Power BI service

HOW TO CREATE AND PUBLISH PAGINATED REPORTS IN POWER BI SERVICE

The following one is a similar topic shared on Power BI Ideas , you can vote it up and add your comments there to improve Power BI on this feature. Anyway, you can also raise a new one there.

Paginated reports - please make it available in Pro as well as Premium

Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[MarkSL · Accepted solution]

Hi @esther21179 

Yes I believe you can achieve this, using a simple matrix table per 'block' you desire.  

Simply add your measures to a Matrix (no need to add any dimensions to the Rows section) and then select 'Show On Row' in the Values setup box.  This will pivot your data from one row per dimension to one column with multiple rows:

I hope this works for you.

Mark

[mahoneypat]

What you've shown would be straight forward as a paginated report with Power BI Report Builder.  You can use your published Power BI Dataset as the source.  Please see this YouTube playlist for how to get started.

https://www.youtube.com/playlist?list=PLx7LcKtN_gq-JVzM6L8xNNxX7kts-KflJ

Regards,

Pat

[esther21179]

Yes, but my company does not have Premium membership. So I can use Report Builder but I can't publish Report Builder reports up to the PBI online service. Is this correct? Any solutions for Professional membership users?

[Anonymous · Accepted solution]

Hi @esther21179 ,

It requires the report be put in the workspace where is in a Premium capacity when the paginated report is published to Power BI service. You can find more details in the following documentations.

Publish a paginated report to the Power BI service

HOW TO CREATE AND PUBLISH PAGINATED REPORTS IN POWER BI SERVICE

The following one is a similar topic shared on Power BI Ideas , you can vote it up and add your comments there to improve Power BI on this feature. Anyway, you can also raise a new one there.

Paginated reports - please make it available in Pro as well as Premium

Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.