Multi-Column Layout in SubReport (paginated reports)
I have an overarching report that consists of a cover page, a subreport that is tabular (with tablix data region) and then another subreport that consists of a 2-column layout (like newspaper) with a List data region. The subreport renders in 2-columns just fine by itself, but when nesting it into the larger report as a subreport AND rendering in Print Layout, the subreport only populates data in one column. How can I achieve this?
Sum a row using visible columns
I have created a table that allows a user to choose what data columns they wish to see (via field parameters). There are up to 4 possible values they can select from. I need to get a dynamic total across each row based on those selected columns. So, for example, if they choose all 4 severity levels, the first row would total 10, second row would be 3, etc. But if they chose only Sev2 and Sev4 (meaning only those 2 data columns would be visible), they would get 4 in the first, 2 in the second etc. There are other values that can be calculated as well (such as year over year percent of change and so on) but those would obviously be calculations similiar to this basic one. What formula would acheive that result?
Function to collect leftover hours if exceeding 8 hours of work?
I'm trying to configure a formula to calculate the 'Overage' Hours of a days work. From my data I did a 'GroupBy' within PowerQuery to condense all my columns to only the necessary fields to narrow down my calculation for easier functionality. However, I'm stuck on this final piece on this calculation. The goal is to be able to track how much time is worked past 8 hours (if you work 9 hours in 1 day, your overage hours would be 1 hour). In addition, a regular work week being 40 hours, I can exceed 40 hours and go into overtime within the same work day. I don't know how to manage this formula to sum 'Regular' hours and 'Overtime' hours together and subtract it from 8 to get the leftover hours worked. My current formula is super simple as I keep trying to build on it, but don't know how to go about it. =IF(SUM[Hours]-8<=0,"",SUM[Hours]-8) Date Category Person Hours 01/20/2025 Regular A 5.5 01/20/2025 Overtime A 3.5 01/20/2025 Regular B 5 01/20/2025 Regular B 4 Person A 1/20/2025 = 1 Overage hour (but 3.5 hours of Overtime) Person B 1/20/2025 = 1 Overage hour (No overtime accumulated yet) This is over thousands of rows of variances of hours worked. Apologies if it doesn't make much sense I can try to clarify more if asked. But I'm still fairly a novice at DAX and Power Query but would love some insight and advice on how to get this solved.
Measure to count columns that have the same strings of text in a different order
Hey Folks, I have a column of data that contains a topic or multiple topics that are seperated by ";" that may be in a different order. I'm trying to count the times particular combinations of topics are put together, i.e. As appears in regular table count Topic 1;Topic 2;Topic 3 - 1 Topic 3;Topic 1;Topic 2 - 1 Topic 4 - 1 Output I'm trying to get to: Topic 1;Topic 2;Topic 3 - 2 Topic 4 - 1 I have found the following solution on Stack Overflow that seems to be exactly what I'm talking about, however the context is for other databases than PowerBI / Power Query. r - Group strings that have the same words but in a different order - Stack Overflow I'm hoping that this is something that can be acheived via a measure rather than within power query. I already have a bridge table that lists all individual topics, so I'm wondering if its something I might be able to leverage as part of the meaure, but I'm very lost on this presently. Thank you for your help.
Sort the columns according to their name.
Hello dear! I need to order the columns of the chart according to the description of each one. For example: the first column "Excellent", the second column "Great", the third "Good" and the fourth column "Terrible". I couldn't figure out a way other than the constants in the axis sort options. Thank you very much in advance if anyone can help.
Industry Filtering Visual/filter
Hi all, I have created a dashboard that visualizes a specific brand's reviews by their rating and theme of review. I used a matrix that visualizes how many reviews are related to a specific theme, subctegories within the themes, and products. I then use columns to break it down further by showing the same data for each individual star rating. What I am now trying to accomplish is to allow the viewer to use a filter or slicer element to choose a specific industry and see the data for the desired industry. For example, selecting "automotive" and only showing data for reviews related to a product that is classifed as an automotive industry product. The data is set up with each row being an individual review. The following columns include data such as the star rating, product id, theme, subcategorized themes, and finally Industry. Where I am having trouble is with the fact that many of our products have multiple industries associated with them. For example one of our products may have all of the following industries: automotive, manufacturing, transportation, and maintanance. I can attach the data as a delimeter separated list in one column or have them split into different columns. However, I have issues with both options. Using a delimeter seperated list - I do not know how to then be able to use that column to use a filter or a slicer filter. I don't have any knowledge if it is possible to use the data in that form. Using seperate columns (6 columns as the products with the most industries has 6 industries) - I do not know how to combine data values (industries, For example manufacturing) if they are in different columns. For example if a product only has 1 industry, manufacturing will be in column: industry.1, but if the product has 3 industries manufacturing may be in column industry.3. Therefore I wouldn't be able to use any of the columns to include all reviews with a manufacturing related product. I'm not sure if this will make any sense to anyone. However, I figured I'd give it a shot. Any ideas, knowledge, or questions are welcome. Thanks!
How to filter one plot by multiple exlusive filters?
I'm not sure if this topic should be here or in Desktop tab, so my apologies if i picked incorrect one. Hi there. I have a task which i'm unable to solve. I need to create a scatter plot showing temperature and population on axes by cities. And every city belongs to some region - nothing unusual. There should be a slicer for user to select region. But here comes the tricky part - i also need to add slicer where user can select city from another region - and this city should be displayed with all other cities. So, for example, when a user select Asia from region slicer there should be displayed all Asia cities, but if user wants to select city from city slicer this city should be also displayed with all Asia cities, even if it's not belong to Asia region. But when you pick Asia it applies filter to all cities, and you can't pick another one from different region. I tried to create two slicers which should filter another one, and data from it should bу displayed, but it doesn't work. Tried to tinker with filter parameters in visual by creating measures but also without success. Even not sure that measures can help because it should work with columns, and we can't change them dynamically. If you have any suggestions i'll be glad to hear.Keep Columns Permanent in Matrix
Hello! I have a matrix with test and control columns where our test group is subdivided into test A and test B. The calculations are perfect and filters work just fine. However, I would want to keep the "Control" columns permanent even after appying filters to say Test A. In that way, I can compare numbers between Control and Test (A or B). Is this possible in Power BI? I am using the native matrix visual. Thanks!CALCULATED COLUMN WITH REPLACED BLANKS
Hello friends, I'm having a trouble with building a DAX Measure to get some values and displays them as row values on matrix. Unfortunately when i use calculate doesn't work, my matrix turns into a huge amount of rows that i dont want. There's any way to only replace blanks without making the matrix "bigger". The quantity column below shows the quantity of a material, the blank values are materials that currently we dont have in storage, we have two tables, one with a list of all material numbers and another with all materials in storage, the first column of this matrix is the material number. Can you guys help me? Thanks so much.
