Process data table to obtain subtotal table
Hello, I have a Database-like table which resumes Work Orders (WO) and Tasks for those WO where there's as many lines as there's Tasks. For example, I have 5 tasks for the same WO where each has their own planned work hours, actual work hours, planned costs, actual costs, etc : I would like to have a second table, from that table, to show WOs with the subtotals only, and keep WO-related data only : Is it something that can be done? Thanks! PS. I know Matrix can do that, but I don't want show the data necessarily with a table.
Default Grow To Fit, Auto-Size Width - October 2025 Release
To PBI developers and fellow users, The new October update bringing Grow to fit as a default has been frustrating to work with. As someone who has used Power BI for the better part of a decade I find it much cleaner and user friendly to manage my column widths instead of arbitrarily assigning widths based on the space of a block. This is how we all have been doing for years. Per the release notes: https://powerbi.microsoft.com/en-us/blog/power-bi-october-2025-feature-summary/ Auto expand table columns The Grow to fit option distributes extra space across columns for cleaner visuals. And I'm not the only one: As Kyle puts it, we are frustrated by being forced default options that, in our opinion, degrade user experience. I encourage making the service easier for new users to drop in things and make it look pretty with minimal effort. But now I have to go into each table and switch this setting each time I want to return to a traditionally auto-sized column. Please make the default "Fit to Content". Or at least give an option to set a client preference for one or the other. Thank you, generatorsam
Filter two tables on Multiple Criteria
Hello! this might be confusing and I can't share any data so I will do my best! I have two tables: SynthesizedItems and Failures. I have a report page dedicated to fail rate. This is just the number of fails/number of synthesized items. (measures in the failure table) Originally, I linked the two tables to a common date table. this allowed me to see the fail rate adjusted based on the users filtering by date. Then, I realized I needed to be able to break this down further. I added an additional table called DepartmentFilter and linked it to department in both the fail and synthesis tables. this seems to work. Now my question. My report has SEVERAL factors involved that users can slice their data by (all coming from the failure table) and I noticed that if the user filters to a certain customer, the fail table will filter but not the synthesized items table. (makes sense because they are not related, although customer exists as a field in both tables). Is it possible to make this method work where any filter the user applies will affect BOTH tables and therefore give an accurate rate? Is there a limit to how many common "filter" tables I can create and link to both? Is there a way to do it other than creating tables for each field? really trying to avoid this since it would be about 10 fields.
Create Dynamic Measure Tables using Values from Slicer
I have a Dynamic Measure Table and need to pass in the slicer value. Unfortunately the value of the slicer is not being passed into it. I tried creating a measure to select value from the slicer and input into the dynamic table and still no luck. The output of the Dynamic table is displayed via a Table Visualization. I tested the Year and Month Measures in cards and they are fine. Has anyone come across this issue before? Selected Year = SELECTEDVALUE('Date'[Year]) Selected Month = SELECTEDVALUE('Date'[Monthnumber]) TestMetricsTable = VAR selectedyear = [Selected Year] VAR selectedmonth = [Selected Month] VAR DataTempTable = DATATABLE ( "Category", STRING, "Year", INTEGER, { { "none", 0 } } ) // RETURN SELECTCOLUMNS ( DataTempTable, "Category", "Selected Date", "Year", selectedyear, "Month", selectedmonth )Proper Calculation of Facts/Values from Dimensional Table
Source ( Download Here ) Userstory: Imagine you have big star shema model and important values/facts in dimensional Tables. And you don't want to mess up your fact table with multiple low cardinality columns. Question: How to proper handle these dimTable facts/values? Simplified Example: Question: How to get DESIRED YearVolume (because by default it gives 2200 (Totals) in each cell)?
