power 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 help
Matrix 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!
Matrix 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?
How 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 meHow 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"?Matrix with flags
Hi everyone, I have 3 datasets: Product, Client, Transactions and Calendar (Some Date - today()) as follows I need to compute the monthly count of transactions for each product starting over the last 15 months. The goal is to be able to flag products with no transactions over the last 15 months (red flag), products with no transactions over the last 12 months but there were some transactions over M-12, M-13, M-14 (orange flag) and products with at least one transaction over the last 12 months (green flag). Here is the sought-for output: product_id || product_name || M || M-1 || M-2 || ... ||M-12 || M-13 || M-14 || Total || Flag 1 Books 1 1 0 ... 0 0 0 2 green 2 Pens 0 0 0 ... 0 1 0 1 orange 3 Pencils 0 0 0 ... 0 0 0 0 red Total 1 1 0 ... 0 1 0 3 Here is the Model I succeeded (with the help of the community) to find the measure computing monthly total of transactions by product, the problem is that the matrix visual doesn't allow to get the output mentioned before where I can add a measure Flag to classifiy products . Another question, is it a good idea to relate the calendar table to any of the main tables ? because I want to filter many dates in the different tables using that date table. Any idea is appreciated ! Thank you 🙂Measure is Turning Blank on Table
Hi, I can calculate the diagonal values according to 2 different dates, but my aim is that create this measure for a matrix with row "customer" and one of the dates. Here is the sample data, StartYear StartMonth CalcYear CalcMonth Customer fixedfee 2023 1 2023 1 100 0.00 2023 1 2023 2 100 0.00 2023 1 2023 3 100 0.00 2023 1 2023 4 100 0.00 2023 1 2023 6 100 0.00 2023 1 2023 7 100 41.07 2023 1 2023 8 100 115.93 2023 1 2023 9 100 62.23 2023 3 2023 3 100 0.00 2023 3 2023 4 100 0.00 2023 3 2023 6 100 0.00 2023 3 2023 7 100 41.07 2023 3 2023 8 100 57.97 2023 5 2023 5 100 0.00 2023 5 2023 11 100 77.95 2023 6 2023 6 100 0.00 2023 6 2023 7 100 82.13 2023 6 2023 12 100 100.88 2023 6 2024 1 100 131.92 2023 7 2023 7 100 1,190.93 2023 7 2023 8 100 289.83 2023 7 2023 9 100 248.93 2023 7 2023 10 100 329.81 2023 7 2023 11 100 155.91 2023 7 2023 12 100 403.53 2023 7 2024 1 100 263.85 2023 8 2023 8 100 1,681.03 2023 8 2023 9 100 622.33 2023 8 2023 10 100 329.81 2023 8 2023 11 100 311.82 2023 8 2023 12 100 201.76 2023 8 2024 1 100 263.85 2023 9 2023 9 100 1,867.00 2023 9 2023 10 100 593.65 2023 9 2023 11 100 77.95 2023 9 2023 12 100 302.65 2023 9 2024 1 100 131.92 2023 10 2023 10 100 1,715.00 2023 10 2023 11 100 467.73 2023 10 2023 12 100 201.76 2023 10 2024 1 100 131.92 2023 11 2023 11 100 1,715.00 2023 11 2023 12 100 201.76 2023 11 2024 1 100 395.77 2023 12 2023 12 100 1,715.00 2023 12 2024 1 100 263.85 The measure that calculates the diagonal values below, turns blank on the matrix when "customer" is on row and "calcdate" is on column, FF_Agg = VAR startyear=SELECTEDVALUE(table[StartYear]) VAR startmonth=SELECTEDVALUE(table[StartMonth]) RETURN CALCULATE ( SUM(table[FixedFee]), FILTER(table,startyear=table[CalcYear] && startmonth=table[CalcMonth]) ) It will be dynamic table under the date filters so, I need a measure instead of calculated table, my aim matrix to reach out, CalcYear 2023 Customer CalcMonth 1 2 3 4 5 6 7 8 9 10 11 12 100 0 0 100 0 100 100 1190 1681 1867 1715 1715 1715 Thank you, Veli
