Page numbering for subreport thats independent of main report (Report Builder)
Hello, I am using a subreport and want to use page numbering but I am only able to use the global page count which includes the count for every page of the report. The subreport needs to display its own page count in this format "Page X of Y". If the main report has 10 pages and the subreport has 3 pages, the subreport 3 pages should show these respectively on each page "Page 1 of 3, Page 2 of 3, Page 3 of 3" I'm currently using this expression but it gets the total count of the report. ="Page " & Globals!PageNumber & " of " & Globals!TotalPages
Power Bi Report Builder(Paginated Report) Dynamic
Hi! good day everyone, i have question, this is the environment : * Power bi Report builder * Datasource is from semantic model * to create dataset is with queries dax i am trying to créate a report in power bi report builder, with this sections: * header * body ( with 3 page columns ) * footer the data is about students, and it must be displayed by year, one year have at least 100 records these records are * header (the generic data student ) * body ( the body is the data subject, and it has to be displayed in 3 columns page) * footer Example At this point, i am able to run one year that has only one student and get header and details but when the year has more one record, i don know how to run massive I want to make a dynamic header for each studentId page, and details Can any one please help me on this? Thanks in advance
Graphs in print layouts are too big
I'm trying to create a Power BI paginated report with graphs. It looks fine when I preview in normal mode, but I can only see a portion of the visual in the print layout. I've tried adjusting font sizes, dynamicheight and dynamicwidth, but that hasn't made any difference. I've tried different visuals, but they all have the same problem. I have other reports that use list data regions and these work fine. Normal layout: Print layout:
Date displaying differently after publication
Hello I have built a visual that uses a slicer. I want the date to be dd mmm yyyy as below, which it is in desktop when I have built the report. For an unknown reason the slicer displays with the day in PBI browser, which is not desirable as it means the user can't actually see the date they are selecting. Does anyone know why this is happening and how I can fix so that it displays the same as in the desktop? Thanks in advance
Can we build a table in calculated filed like attached image?
Hi, I need to build the like below: Can we build the above table? How can we build the fileds at Left Side like Gross Sales, REBATE, RXs etc?means Left Side columns are measures, and should show under PRODUCT SET DESCRIPTION collumn. So, can we create column like this?
Power BI Report Builder_ Failed to preview report
I am trying to build a paginated report on Power Bi report builder. I have a valid stored procedure on my SqlServer DB. To keep the consistency of the design ( formatting, colors, text aligning) I created a copy of the existing report and deleted the dataset which was in it. And added my own dataset. Deleted the tablix column content from the existing report copy and filled the columns with my datasets columns. But when I run the report, it shows: " The hidden expression for the textbox 'Textbox11' has ascope parameter that is not valid for an aggregare function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset". Did anybody come accross this issue in the past? How could you solve it?
Can Output from Power BI Dashboard on report server, be made as input to another power BI dashboard?
My organization, we create dashboards on Power BI Desktop, and then publish to host on Power BI Server. I would like to know if there's a possibility, that output of one dashboard, can be treated as an input to another dashboard? Example: Dashboard 1: Creates a list of the clients according to filters used.. User then clicks on a button (or any other way), to open the Dashboard 2 Dashboard 2: Uses the Dashboard1 output as input, and filters the metrics accordingly..Assistance with Setting Default Parameter to "All" in Paginated Reports
I am currently working with multiple text parameters (such as Country, Customer, and Category) in a paginated report and would like to set "All" as the default selection for these parameters. Could you please confirm if it's possible to configure this in the report? Additionally, any guidance or steps you could provide would be greatly appreciated. Thank you for your support. I look forward to your response.
