Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper II
Helper II

Report Builder - Table or multiple tables to show data on whole page



I have a little struggle with the feature of Paginated Report, that is the table. The desired view is something like this:


It is a setup of categories with assigned answers to them represented by background colour. The crucial thing is that it should go to the next column when the page ends. So far I managed to do something like this:


And in Design mode it looks like this:


Basically - this is good. The background of the second column is the indicator of the answer. I do not have sufficient data yet to test how it rolls when it reaches the end of the page, but I suspect that it will break to another page - which I would like to avoid and point it to the next column.

I have a limited number of options, let's say 32, so I'd need four columns 8 rows each. I was thinking about counting rows in this table, creating three additional and allowing only ranges of 1-8, 9-16 etc. but maybe there is a faster and easier solution? Also, I am thinking about how to check row position? I know there is RowCount() but I think it works for the dataset - how to limit it to only the table?




Helper II
Helper II

Has anyone had a somewhat similar issue? Or at least maybe could help with counting rows of the table/this dataset?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors