paginated reports
4 TopicsHow to filter sum function within Tablix using value within row
Im having trouble with power BI Report Builder for somthing that feels like it could be pretty simple but isnt and it may be because i dont understand how to refrence values that are in diffrent scopes. Basically i have 2 tables, one is a table that just has jobs listed on it(So like Project Manager, Anylist, that kind of thing) and another that lists hours worked each week by diffrent people, and it includes a column that refrences what position they are, so it would be a one to many relationship between Job DataSet and Worked DataSet on their column. I have a tablix that is using the Jobs DataSet and what i want to do is have a column that sums up all of the hours worked, but filter it so that it only sums up the ones who their Job column is equal to the Job value of the row on the table, but i just cant get it to work. I can get it to only sum up ones whos Job column matches a static string, and a perameter, but i just cant for the life of me get it to use values within the row itself. Anyone have any help? Thanks!Solved408Views0likes1CommentHow to page break by group in a paginated report
Hi, is there a way to page break by Make in this example so that you actually get two tables instead of one? I tried to add page break by Make group but nothing happens. The bottom two tables - per make is just a filtered view of the matrix that has both. Any suggestions? Thank you9.9KViews0likes4CommentsPaginated report auto refresh datasource
I have a Power BI data source and want to create a Paginated Report. The thing is that my data is refreshed on a monthly basis, and the reports must be up to date. I didn't find any information regarding whether when the data source is updated, it will automatically be updated in my dataset in the report builder or paginated reports. For example, the database in my power BI is up to September, cause data in October hadn't been updated yet (since it's the current month). However, in November, I will need to export the paginated report for October, so the data source will be updated. What will happen here, I will have to create a new one. Can I refresh data like I do in Power BI?4.7KViews0likes1CommentPaginated Reports Design Functionality
Is it just me or are the report design options in Power BI Report builder extremely limited? I want to create a paginated report to distribute via email to a client list of around 200 members. I have a dataset with banners and logos for the clients. I want to design a cover page for a paginated report that includes a semi-transparent version of a client's banner image. But I can't seem to adjust the transparency of images. And I also can't seem to add shapes like triangles or waves (I want to shape the image so it is not just a rectangle). Are there any plans for adding basic design functionality like adjusting image transparency and adding shapes to Paginated Reports? Am I the only one that finds this deficit extremely limiting?2.4KViews0likes2Comments