Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I am just starting out with Paginated reports and PBI Report Builder.
I have a PBI Dataset where I have Sales data per Customer per month. I would like to create a paginted report which is printable and have a chart per unique customer, per page
I would like to know if it is possible to have a chart per page per category. ie.
One Chart per page, filtered per Customer in my Customer Column
Sample Data:
Page 1:
Page 2:
etc.
Thanks in advanced
Solved! Go to Solution.
One way to achieve this is to drop the chart into a single cell matrix and control the page breaks with the row group settings. See below gif and attached .RDL file (attached as zip as .rdl extensions aren't allowed to be attached directly).
I hope this helps.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
I'm glad that worked @Anonymous.
It's actually the first time I've opened PBI Report Builder. I haven't done any paginated reports in years, however, it is very familiar to me because, from what I can see at first glance, it is the same as SSRS tools.
So if you want to learn more in this space, I'd recommend basing your searches on SSRS not PBI Report Builder.
I'm not sure exactly what you're looking for but the link below might be as good of a starting point as any.
https://www.mssqltips.com/sqlservertip/6816/getting-started-with-ssrs/
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
One way to achieve this is to drop the chart into a single cell matrix and control the page breaks with the row group settings. See below gif and attached .RDL file (attached as zip as .rdl extensions aren't allowed to be attached directly).
I hope this helps.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
This is Brilliant! Thanks @KNP
Is there somewhere I can learn more about PBI Report Builder (Except YouTube)? It will give some great expansion to my current reports, and super keen to understand it a bit better.
I'm glad that worked @Anonymous.
It's actually the first time I've opened PBI Report Builder. I haven't done any paginated reports in years, however, it is very familiar to me because, from what I can see at first glance, it is the same as SSRS tools.
So if you want to learn more in this space, I'd recommend basing your searches on SSRS not PBI Report Builder.
I'm not sure exactly what you're looking for but the link below might be as good of a starting point as any.
https://www.mssqltips.com/sqlservertip/6816/getting-started-with-ssrs/
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Thank you so much. Much appreciated.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |