matrix visual
17 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 - 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 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.3KViews0likes7CommentsReport matrix visual which is not updating
Hi all, I created a report with on one page a slicer and the other page a matrix which is controlled by the slicer. With the slicer I can filter on costumer-name. The matrix contains conditional formatting and a lot of collapsable data (so I have a vertical scrollbar on te right, as it doesn't fit on 1 page) What I want is a visualisation which can be shared with my customer. The visual needs to shows the matrix but the slicer can not be altered. So customers can only see their own data and not that of other customers. (can also be a dashboard, powerpoint, excel, pdf etc) I tried exporting to powerpoint. But embedded as image, does not give the customer the ability to scroll and collaps/expand. And embedded as live data, the customers need a powerbi licence themself to view. I also tried create subscription. But than all customers get the samen filtered data, and nit just their own. Can anybody help me out? Regards, Yvonne By the way I have a powerbi Premium per user licence.1KViews0likes2CommentsRelative Positioning on Shapes Changing Based on Resolution
I'm trying to create a sort of dynamic PNL using the basic matrix visualization. The issue is that I want subtotals for each of the bolded catergories, and then a grand total (Net Income). I've created a matrix that functions properly, but there are extra lines of data that repeat catergory sums. In order to negate this issue, I placed grey shapes over the unwanted rows to hide them. The issue is that when I view the report on screens of different resolutions, the shapes move slightly. This movement will cause the shapes to be covering the wrong rows of data. Is there any way to either A) lock the shapes in place relative to the matrix or B) insert custom subtotal rows in a matrix? Attached is a screenshot of the first column of this matrix, with the shapes in place below "Total Utilities" and "Taxes & Insurance"1.6KViews0likes3CommentsDisplaying a text column in a measure/matrix
Hello, I have a measure I am using in a matrix as kind of a summary for multiple companies. I am using switch for the column headers and then I have multiple different CALCULATION functions for displaying what I need. However I am having trouble displaying a column that is supposed to show the category for the companies. The data is text. I have tried SELECTEDVALUE and that works if I have slicer and pick that specific category but I want to show the matrix for all categories at the same time, any ideas? Thanks 🙂2KViews0likes4CommentsGroup by Measure in a Matrix
I have been searching for answers on this and have found several things that might work but I don't understand how to use them. Hoping someone can help me understand. I will try to explain what all I have and what I am trying to do. I have a measure called AverageDailyWorth that is just a sum of the customers spend divided by the number of trips they have made. I have a second measure using the switch function to roup the customer into ranges based on the AverageDailyWorth. So for example into groups like $0-$14, $15-$49,$50-$99,$100+. The goal is to have a Matrix that lists all of these groupings on the rows and then I can get the combined sum of values in columns for all the members in each group. This is super simple in Excel as I would just do a vlookup to assign to the Grouping and then do a pivot table based on the column from the vlookup. However recreating pivot tables in Power BI seems to be impossible when you are using a measure. At least to me. I have found the following ideas in my reasearch on this and they might or might not wok but with my limited understanding of the I have not gotten a workable solution: disassociated table virtual table virtual relationships I am still very new to Power BI and this foru as well. If there is a way I can provide a file with sample data and that is useful please let me know how. I will gladly make a mock sample file in Power BI as well as the expected result from Excel I would like to recreate.Solved1.1KViews0likes2CommentsRequire Color Coding For Pivot Table in Matrix Visual (Power BI Server - May 2020)
Hi, Can someone please help me to color code the entire row based on the text value for "Bench category" even if the value is empty or null. Right now in BI, I have obtained below output: But the final output should look like this as shown below: Thank you in advance for the help.1.1KViews0likes2Comments