PBI Report Server doesn't render correct font for groups that toggle hidden fields
In paginated reports where I added groups that can be used to toggle hidden fields, the font and fontcolor of those groups is not displayed correctly. I use a XML dataset which holds the fonts and colors I want to use in my reports. When I preview the report in Visual Studio, Report Builder or SharePoint everything looks fine, but when I deploy it to SSRS PowerBI I see a font that looks like Times New Roman instead of Segoe UI that it's supposed to show. The fontcolor is black, while it should be red. It does show the correct backgroundcolor. When I do not use the dataset to render the font and just add Segoe UI in the textbox properties everything works fine. Is this a bug or am I missing something?
DAX Measure - Group Total in each customer number row
Hi, I have a seemingly simple question, however, I just can't seem to get it right. My question is the following: I have customers divided into CSAC3 groups. So a customer belongs to a specific CSAC3 group. I have also created a measure that calculates the turnover TY. However, I now want to have a measure that adds up the turnover of the CSAC03 group and displays it behind the relevant customer number with the associated CSAC03 group. What I keep getting now is that it filters this turnover by customer number each time anyway. Ultimately, I want to calculate further using this turnover per CSAC03 group. But I can't get this to work. Below is an image of the table with columns Customer number, CSAC03 and Turnover MAP TY. This is on a customer number basis. Now I actually want another column next to it with Turnover MAP TY (CSAC03). So all the customer numbers with CSAC03 ‘4PLUS’ should include the total of this CSAC03 group. Furthermore, the code of the measure, perhaps this also has something to do with it. The tables are connected by means of customer keys/customer numbers. If anyone can help, please do, thank you!
Grouping dates into fortnights
Hi everyone, I'm looking for a solution that will help in grouping dates into fortnights, irregardless of month or year. I'll attach an image to help understand what I am meaning. It wouldn't matter if the column started at calendar start or a specific date. The date table I have is just an invoked funtion in M. Hopefully someone can help, I'm not sure what other information I could provide that would be helpful here.SUM grand total per category
Hello everyone! I am new to Dax and am guessing the solution is right under my nose, but I've exhausted my limited knowledge and need some guidance. I have category (location) and subcategory (centers). A location can have more than one center. My dimension table Unidades uses the subcategory as primary key, since they aren't duplicate. There's also a fact table containing the amount of extra hours (R$) per location (category). When I put the information on a visual it repeats the corresponding overtime for every center according to its location. That's OK. My problem is that I need to add up the grand total of overtime hours, but my measure is adding the overtime for each center and not the location, wich means it adds duplicate values. How do I get the correct sum? Thank you in advance.
Specific transformation on table
Hi Everyone, as you can see below, I have data in the format in the "Initial Table" that I'd like to transform to the ones in the "Transformed Table". Specifically, I'd like to group my data by order number but the resulting value should be a string in this format <Quantity><Product>-<Quantity><Product>-...-<Quantity><Product> But first sorted by Product. Is there a way to perform this in PowerBi in Power Query, please?Get the Quantity by the Earliest Date
Hello, I am trying to get the most recent quantity by production week, by Plant (Where it is produced) and by SKU (Item No) depending on the earliest date (version date). Can someone help me with this. I do not mind if it is done in DAX or Power Query. Below is my data view. I have tried groups but when I try to get the quantity it sums all the values up. I dont want that I want what ever was the quantity by the earliest plan version by item. ========================================================== Example of what I want: If I were to sum the quantity of production week of 9/25/2022 I would get like 900,000 (LBS) because it sums it all. I want to get the last value depending on the earliest or closest date of that production week for that Item and plant level. Let me know if I need to clarify anything. Below is an example of why the equal dates do not work:
