tips and tricks
52164 TopicsNavigate Between Multiple Power BI Report Server Reports Inside Power BI Mobile App
Hello everyone, We are using Power BI Mobile with an on-premises Power BI Report Server. We have multiple Power BI reports, and we would like users to navigate from one report to another using buttons inside the reports. For example: Report 1 → Report 2 → Report 3 Our goal is to keep the navigation inside the Power BI Mobile app. Currently, when we use the normal Power BI Report Server report URL in a button, the link may open through the mobile web browser instead of opening the target report directly inside the Power BI Mobile app. Is there an officially supported way to navigate between different Power BI Report Server reports while staying inside the Power BI Mobile app? For example, is there a supported deep link, URL format, or another navigation method specifically for on-premises Power BI Report Server? Please note that we are using Power BI Report Server (on-premises), not the Power BI Service. Thank you for your help.133Views1like4CommentsPower BI interpreting DD/MM/YYYY dates as MM/DD/YYYY when day is 12 or below
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Hi, I'm having an issue with dates coming from an Excel source into Power BI. The source dates are intended to be in UK format (DD/MM/YYYY). However, dates where the day is 12 or below can be interpreted as MM/DD/YYYY, which moves transactions into the wrong month and significantly affects the monthly totals in the report. For example, an intended date such as: 08/10/2026 = 8 October 2026 can potentially be interpreted as: 10 August 2026 The problem is particularly difficult to identify because dates where the day is greater than 12 cannot be interpreted the other way around, so the issue appears to affect only the ambiguous dates at the beginning of each month. The report uses an Excel source and the affected field needs to remain a proper Date data type because it is related to a Date table and used for monthly filtering and measures. I would like to ensure that Power BI always interprets the incoming values as: DD/MM/YYYY / English (United Kingdom) rather than relying on automatic locale detection. What is the most reliable way to enforce this at import/Power Query level so that it remains correct after refresh and after publishing?72Views2likes5Commentsnew input slicer - how to paste multiple items?
I am trying to filter multiple values using new input slicer I enabled multiple values option However, when I try to paste more than one item into the slicer from excel or notebook , values that I enter are concatenated and are not treated as separate values Does anybody know how to paste multiple items from excel/notebook? I know that I can enter values one by one but with more items it is problematic. Is this a bug?Solved1.6KViews0likes3CommentsHow do you handle subtotals that don't equal the sum of child rows?
Hi everyone, I'm looking for advice on how others handle a reporting scenario involving distinct counts in a matrix visual Electronics 150 Online 120 Retail 80 Wholesale 40 So user would expect 120 + 80 + 40 = 240 and wonder why total is only 150. The reason is that the value is a Distinct Count of Customers. The same customer may appear in multiple sales channels, so the subtotal is recalculated at the category level rather than being the sum of the visible rows. My measure DISTINCTCOUNT(CustomerID) is a non-additive measure, so parent totals don't equal the sum of their children. My questions is how do you typically present this to business users and do you leave the matrix as-is and provide an explanation? Thanks126Views2likes13CommentsGuidance Required: Configuring Microsoft Copilot with Power BI for AI-Powered Analytics
Hello, We are exploring Microsoft Copilot capabilities in Power BI to enable users to ask questions in natural language, receive text and tabular answers, generate charts, and create or modify reports using existing datasets. Could you please help clarify the following? What licenses, Fabric capacity, and tenant settings are required to enable Copilot in Power BI? Can Copilot generate visualizations and reports directly from natural-language prompts? Can Copilot be integrated into an existing web application? Do existing Power BI permissions and row-level security remain enforced when Copilot is used? What is the most cost-effective setup for a proof of concept, including licensing and capacity costs? Are there any significant limitations related to dataset size, performance, or supported data sources? Our goal is to validate these capabilities through a small proof of concept before considering a wider implementation. Any recommendations or links to relevant documentation would be appreciated. Thank you.26Views1like2CommentsCalculated function in Direct Query
I try to achieved this calculated column and work fine in Import Mode but In Direct Query it does not work for CALCULATE and REMOVEFILTERS. how could i possible to achieved it? Test = VAR CurrentDate = Workstation_HealthCheck[checked_at] VAR CurrentIndex = Workstation_HealthCheck[id] VAR PreviousDate = CALCULATE ( MAX ( Workstation_HealthCheck[checked_at] ), Workstation_HealthCheck[id] = CurrentIndex - 2, REMOVEFILTERS ( Workstation_HealthCheck ) ) VAR TimeDifference = DATEDIFF ( PreviousDate, CurrentDate, HOUR ) RETURN IF ( ISBLANK ( PreviousDate ), "UP", -- Or "First Check-in" IF ( TimeDifference > 4, "DOWN", "UP" ) )33Views0likes1CommentCalculated function in Direct Query
I try to achieved this calculated column and work fine in Import Mode but In Direct Query it does not work for CALCULATE and REMOVEFILTERS. how could i possible to achieved it? Test = VAR CurrentDate = Workstation_HealthCheck[checked_at] VAR CurrentIndex = Workstation_HealthCheck[id] VAR PreviousDate = CALCULATE ( MAX ( Workstation_HealthCheck[checked_at] ), Workstation_HealthCheck[id] = CurrentIndex - 2, REMOVEFILTERS ( Workstation_HealthCheck ) ) VAR TimeDifference = DATEDIFF ( PreviousDate, CurrentDate, HOUR ) RETURN IF ( ISBLANK ( PreviousDate ), "UP", -- Or "First Check-in" IF ( TimeDifference > 4, "DOWN", "UP" ) )Solved56Views1like2Commentssemantic model design and DAX
Hi all, I need some help to resolve some issue. Currently I have 4 tables. there is service table which contains all service approved. There is a table called transfer which recorded when a service is transferred from one owner to another owner within the same state or from other state. There is a table called complaint which records all complaints a service received There is a table called compliance action which records all compliance action which a service being issued. The purpose of the project is to measure what is the impact when a transfer of service happened. it is measure by #complaint and # compliance action. In the semantic model, I cannot link the transfer table with the complaint or compliance action table directly since the multiple transfer with multiple complaint/multiple compliance action. What can I do to overcome this design and be able to measure # complaint before and after a transferred occurred # compliance action before and after a transferred occurred. the current measure below does not take a factor into the account where there is multiple transfer and multiple compliance action. eg there are 2 transfer, 4 compliance action. instead of showing 4 compliance action, the result will return 8. Is it possible to create a workaround solution to resolve this issue? Compliance actions = countrows( filter( 'DimCompliance Action', 'DimCompliance Action'[Service ID] in VALUES ('DimTransfer'[Service ID]) ) Compliance action Before Any Transfer = CALCULATE( COUNTROWS('DimCompliance Action'), FILTER( 'DimCompliance Action', 'DimCompliance Action'[Date compliance action issued] < CALCULATE( MIN(DimTransfer[Actual Transfer Effective Date]), ALLEXCEPT('Service Fact', 'Service Fact'[Service ID]) ) ) ) )44Views0likes2CommentsReduce Category Header Height in New Card Visual
Hi Community, I'm using the New Card Visual in Power BI and have enabled the title with a blue background and white text. As shown below, the Category Header area appears quite tall compared to other visual titles (such as chart titles), and I'm trying to reduce the height of the blue header section to make the KPI cards more compact and visually consistent with the rest of the report. I've already tried: Reducing the text size Checking Multi-category Layout settings Looking for padding or spacing options ( I have made it to 0) However, the header height only decreases slightly and still occupies more space than desired. Question: Is there any way to further reduce the Category Header height in the New Card Visual, or is there a minimum height limitation built into the visual? Ideally, I'd like the header to look similar to the title bar shown in standard chart visuals. Any suggestions or workarounds would be greatly appreciated. Thanks in advance! Current Card Visual: Desired Appearance:Solved95Views0likes7Comments