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!
Feature to group tabs
Hi Team Im currently working on a rather big project, with the stakeholdes wanting more and more different repports. As of new i have about 30 tabs + 10 costum tooltip tabs. The bottom horizontal scroll bar is suboptimal for this amount of tabs, and i would love the idea of grouping them together, and then toggle the groups when needed. So i fx. could put all of my tooltips in one group, and only show them when needed. Hope the idea is well recieved
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?
