Forum Discussion
Create Multiple-Column report in Paginated Report with Report Builder
I think after more research I found out how to do it.
Very simple, just did not see the option in there in the first place!
If you don't see the "Properties" bar, you can click on View and then tick "Properties".
When viewing the "Report" properties, you have a column option. Set that to the desired number of columns you want to see.
I had to fiddle around with mine. I was displaying a table, but had to set it to 6 columns in order to display only 3 columns on the printing. No idea why!
Another thing to note, when you click on "Run" to preview your paginated report, you will only see one column. Took me hours to figure this one out....just click on "Print Layout" once the report has finished running and you will see what it will look like when you print it!
Hope this helps somebody else in the future, as I could not find a single article explaining how to do this in Power BI Reports!
I think after more research I found out how to do it.
Very simple, just did not see the option in there in the first place!
If you don't see the "Properties" bar, you can click on View and then tick "Properties".
When viewing the "Report" properties, you have a column option. Set that to the desired number of columns you want to see.
I had to fiddle around with mine. I was displaying a table, but had to set it to 6 columns in order to display only 3 columns on the printing. No idea why!
Another thing to note, when you click on "Run" to preview your paginated report, you will only see one column. Took me hours to figure this one out....just click on "Print Layout" once the report has finished running and you will see what it will look like when you print it!
Hope this helps somebody else in the future, as I could not find a single article explaining how to do this in Power BI Reports!