matrix visual
82 Topicspower bi report server January 2025 matrix visual
I have Power Bi Report server January 2025 (Version1.22.9153.7886(January 2025)) , creating a very simple report using Microsoft Power BI Desktop (Optimized for Power BI Report Server - January 2025) (Version: 2.138.2255.0 64-bit (January 2025)) The report has one slicer and one matrix, I save the report to report to Power Bi Report server January 2025 , the matrix does not work corretly. in the img bellow the state column is a hierarchy! in the desktop it show correctly but not in Power Bi Report Server. please helpSolved1.7KViews0likes4CommentsMatrix visual missing 2 rows when uploaded to Report server
Hi Everyone, I have created a report with multiple pages and visuals in it. 2 of the pages contain matrix visual and I can see all the rows and values in the deskop version. Whereas, when I upload the report to the report server, 2 of the rows are missing. How is it possible? How can i correct this? Thanks in Advance!1.2KViews0likes6CommentsMatrix Visual is not custom sorting on the Column level. sort by column for matrix column
Matrix visual is by default sort the column data on alphabatically and like rows it doesnt give option to sort Matrix column data on using sort by column option. To achieve this we need to workaround either give numaric or alphabatical range infront of column values which looks very clutter and confusing. With Numaric range as workaroud: By default behaviour:2.3KViews1like0CommentsMatrix visual - Tabular layout problem
The tabular layout option for the matrix visual was introduced in May. When I set "Layout" to "Tabular" in Power BI Desktop RS (May 2024); the visual is displayed correctly; however when the report containing this viusal is published to Report Server Version1.20.8910.25479 (May 2024), the visual does not render correctly and it is displayed using the default "Compact" layout. I suspect that the server does not yet support the updated matrix visual; any ideas? Thanks.Solved1.2KViews0likes2CommentsMatrix drill/expand options disappear when published
I have a report that requires functionality to drill both on columns and rows. This option exists in the desktop version as shown below: Once this report is published to a workspace that feature diaspear along with a few other options: We have several reports with similar functionality, but this is the only matrix where this issue occurs. Any ideas on how I can get this functionality to our production version?Solved589Views0likes2CommentsMatrix visual shows extra blank rows (abnormal)
Hello, I have an issue with viewing matrix visuals on Power BI service. When I edit the report in Power BI desktop, I chose to show a "non-stepped layout". However, when published to Power BI service, the matrix automatically becomes "stepped-layout" and has extra blank rows. Is there a reason why there is this behavior ? Thanks, AnnieSolved3.3KViews0likes7CommentsHow to prevent a measure from being duplicated in each column when using a matrix in Power BI
Hi, hope you have a good day. Please your help with this, I have not been able to find the way to create this visual in Power BI and it seems to me quite simple. I have used the matrix where I can show the measure A for each selected month, so far so good. Now, I need to add a single column with a calculation that takes into account different months (Measure B), "similar to a total but with a specific operation, not a simple sum, average etc" when i add the value the column is duplicated by every month and the value is affected by this filter, I just need to show it at the end of the table once. This is the example in excel of what i want to do, I have looked in the customization options of the table but I can't find the way to do it. I would appreciate it if someone could help meSolvedHow do I group columns by category in the same pivot table in excel?
Good afternoon guys, what's up? I need some help I'd like to layout the PowerBi "Matrix" in the same way that the "Pivot Table" groups the categories before showing the value, as shown in the photos below. 1. Excel - Pivot Table In the image below we can see that the pivot table first categorizes the values - Volume/Weight and Volume Measure - before grouping by BAT/PMI and JTI 2 - Power BI - Matrix In Power BI, the "Matrix" does just the opposite, first it categorizes BAT/PMI/JTI and then it categorizes the values I would like to know if it is possible to visualize the "Pivot Table" (example of photo 1) in PowerBI with "Matrix"?698Views0likes1Comment