Export matrix visual with current layout and data in PBIRS
Hi All, i understand that it is a restriction for PBIRS. Is there any good 3rd party visual can be used in PBIRS and export the data with current layout? i have tried some visuals, but they did not meet my needs. some matrix have performance issue and some lack of export functions. BTW, the original of Matrix in power bi desktop is perfect enough for me. both performance and functions.
Getting one extra row while exporting paginated report to excel
THIS ISSUE IS RELATED TO POWER BI REPORT BUILDER: I have built a Matrix in PBI report builder (Paginated Report). Whenever I export the report to Excel, I get first row of every row group duplicated at bottom. This issue is not found when exported to other formats like PDF, Word, CSV. Any help would be appreciated!Return to the original matrix row when returning from the detail sheet
Hello. Maybe someone has encountered such a situation and found a solution. There is a report with a matrix in the form of a central visual element, in the rows of which the products are displayed. Detailing for the selected Product by Warehouses is configured on a separate report sheet. The matrix is initially sorted in descending order of quantity. There are many rows with products in the matrix and the user, viewing the report and finding himself in the middle of the list of products, goes to the detail page, after which he returns to the main page by the "Back" button. The problem is that when returning to the original page, it is updated, the matrix is sorted by the Quantity field, and the user again finds himself at the top of the list of products, and in order to continue working with the next product, you need to remember which of the products he stopped at, find it in the list and continue viewing from it Is there a way to focus on the product (row) from which he went to Detailing when returning? Example of report behavior on video https://1drv.ms/v/s!AlAn0tcgdpTKjYg9lVb__wMpDdcJ6w?e=36EIAX P.S. I use PBIRS
Matrix Format Changes When Published to Power BI Report Server
We recently upgraded to May 2024 for Power BI Report Server and we're running into a very weird problem. Maxtrixes are not allowing us to use the Tabular or Outline formatting when published. They loook fine in desktop, but once on the server, they look like the default Matrix layout. Example Below: How it looks in desktop: How it looks on the Server: This is the desktop software version: And this is the RS version: Please help! This is driving us crazy!
Dynamic Column Headers in matrix - Report Server
Hi everyone: I would like the matrix headers to be partly static and partly dynamic. Like this below The base structure is simple, I have a fact table, a calendar table and several dimension tables in a star schema. For my part, try the following. 1- Create an order column in the calendar table Orden = YEAR(CALENDARIO[FECHA]) * 100 + MONTH(CALENDARIO[FECHA]) 2- Create a summary table of the fields I need to use as a slicer TablaApoyo = SUMMARIZE( CALENDARIO, CALENDARIO[FINMES], CALENDARIO[Orden], CALENDARIO[Mes]) 3 - Create a measure that if the maximum order field in the calendar table is equal to the maximum order field in the "TablaApoyo" or equal to the maximum order value - 1, then calculate the units. In the case of the month of January, create another if condition, changing the -1 to -89 because the -89 indicates exactly the difference between January and December PRUEBA = IF( MAX(TablaApoyo[Mes] ) = 1, IF( MAX(CALENDARIO[Orden]) IN {MAX(TablaApoyo[Orden]) , MAX(TablaApoyo[Orden]) - 89 , MAX(TablaApoyo[Orden]) - 100}, [Unidades], BLANK() ), IF( MAX(CALENDARIO[Orden]) IN {MAX(TablaApoyo[Orden]) , MAX(TablaApoyo[Orden]) -1, MAX(TablaApoyo[Orden]) -100}, [Unidades], BLANK() ) ) As a result I get the dynamic header but I cannot add the text correctly with this approach. This is the result I appreciate in advance any help you can give me. Here is an example file and i based myself on this video for the solution in part, but it's not what I'm looking for.
Matrix Row Height is Expanding in Power BI Online Published Report and Misaligned with Custom Shapes
I have a matrix with row padding = 8, value font size = Segui 12, column header and row headers font size = Segui Bold 12. Matrix is aligned with several layered shapes. I have one customer for whom the matrix is expanding in size and thus becoming misaligned with the shapes around it. I cannot replicate the problem. We have the same computer with the same settings. I have tried: - Locking visuals - Turning off text-wrap for columns and rows - Changed row padding to 9 - Fixed aspect ratio - Groups matrix and shapes What else can I do?
Issue when exporting data from a matrix
Hello all, I have the issue that when I create a measure to be shown at a certain level of the matrix, other than the very first level, I am able to export that data column and view it along with the others. The problem comes when I try to create a similar measure but that will be shown only at the very first level of the matrix, and not the rest, export data shows for that column as blank. So I've tried different approaches of creating the measure, but none of them seem to work if the measure appears at the very first level of the matrix, but it does work when exporting for other sublevels. Any facing this issue before, PFA the image to see better with sample data. Thank you in advance for your help.
