Matrix Table where measures are not aggregated by month
I was wondering if this would be possible to accomplish in Power BI. I want to be able to have a slicer that the user filter maybe on 3 months 3 years and be able to see the sold by month and weight for the months selected, also adding measures. Measure could be at the end not necessary in the middle as view below. In the past I have built a matrix measure to order the columns, but usually the months are static and there is not date filter. What I am looking to build. I DO NOT want to look like this where the measure/calculations are aggregated by month. Any thought or way to go about this would be greatly appreciated.
Data Explorer glitched on scroll
Good afternoon, everyone! I've been experiencing some issues with the Data pane in Power BI Desktop. Whenever I scroll up or down, the panel glitches, causing the list of tables and fields to freeze or stop updating visually. I've already tried repairing the installation, reinstalling Power BI Desktop, updating to the latest version, and updating my graphics drivers, but none of these attempts have resolved the issue. Has anyone experienced something similar or found a solution? I've attached a video demonstrating the issue. In the video, I first scroll up, wait for the glitch to disappear, and then scroll down. As you can see, the problem persists in both directions. Any help or suggestions would be greatly appreciated. Thanks in advance!
Power BI Copilot for citizen developers: how do you prepare data and govern it in Fabric?
Hi all, While working on a citizen developer program at DataToBiz, we ran into some data readiness and governance questions around Copilot that I’d like to compare with how people here handle them in Fabric. The goal was to let non-technical employees build their own tools and reports. On the app side, they used Power Apps and Power Automate with Copilot, and Copilot Studio for custom prompts and reusable templates, with Azure OpenAI Service behind the natural language features. On the data side, Azure Data Factory and Synapse Analytics unified the sources, Azure Data Lake and Dataverse provided the storage, and Power BI Copilot dashboards gave teams self-service KPIs. Governance relied on Azure AD for identity, Purview for lineage and compliance, RBAC and Azure Policy, and Azure Monitor with Power BI dashboards to track productivity, AI accuracy and ROI. Looking at that stack now, I’d like to ask how you’d approach it in Fabric. Copilot in Power BI is only as good as the semantic model behind it. How do you prepare models so that natural language questions return reliable answers? Do you rely on descriptions, synonyms and AI instructions, or does it mostly come down to simplifying the model? How do you measure AI accuracy in practice? We tracked it alongside usage in a monitoring dashboard, but I’m not sure that’s the best approach. Has anyone found a better way to catch wrong or misleading Copilot answers? On the data layer, would you still keep Dataverse alongside a Lakehouse, or would you bring the Power Platform data into OneLake? How well does that work in practice? For governance, how do you keep Purview, workspace roles and RLS consistent when many non-technical users start building their own items? Where did you have to add guardrails? And how do you watch capacity consumption from Copilot use as adoption grows? Would love to hear how you’d approach it.Subscriptions now coming "from" subscription owner
According to this article https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-troubleshoot-subscribe Microsoft has made the unilateral decision (and apparently without a proactive announcement) to have email subscriptions come from the creator/owner of the subscription instead of a generic Power BI email address, if the creator/owner uses Exchange Online. This is causing all kinds of headaches in my organization, because I personally set up many subscriptions on behalf of others, and now not only are they being received with a different sender, all of the individual emails are showing up in my Sent Items folder. The emails also now bypass out email security systems that all external emails go through. Has anybody figured out a way to reverse the changes or otherwise perform a workaround (setting the owner of a subscription to a generic or service user, etc.) ? Thanks David
No XML option on Lakehouse destination
Hi, I have a requirement to connect to a third party 'API' that spits out XML only. I notice I dont have the option to save XML to a Lakehouse Destination via a Copy Activity. Documentation specifies XML should be supported (Configure Lakehouse in a copy activity - Microsoft Fabric | Microsoft Learn) Have tried creating a brand new Copy activity explicitly setup with an XML file format so I could rule out any other setup causing this.
Monthly average line chart — Some months legitimately have no data
I have incident data from Jan 2010 - July 2026 (17 years, but 2026 is incomplete; some records not entered yet). The data is stored in a MS list and used in Power BI Service. I want a line chart that shows the average monthly incidents to look at seasonal trends. I was vaguely aware of the "date trap" with averages on incomplete years, when it comes to the months remaining in 2026: Aug-Dec. But I hadn't considered the "date trap" for other so-called incomplete years. For example, there are no incidents/rows for April 2013. The data isn't missing; there just weren't any incidents in that month. Power BI has taken the total incidents for all Aprils in the data, dividing by 16 years = 2.1 April average incidents. But when checking in Excel, I took the total incidents for all calendar Aprils, dividing by 17 years = 1.9 April average incidents. I think what I did in Excel is correct for April (a month that had past years with no incidents). But perhaps Power BI is right for the latter half of 2026. Regardless, I'm more concerned about the April scenario and less concerned about the Aug-Dec 2026 scenario. In Power BI Service, how can I create a line chart of the monthly average and correctly handle past months that legitimately had no incidents?Power BI Display Units Decision
below is the data of Line & Clustered chart in tabular form , the chart displays values in Millons (M) , Y axis scale is set as Auto and same Auto for Display unit, the data labels of PY Actuals and CY Plan are turned off, you can see all values are less than 1 million then why power bi is displaying values or data lables and Y axis values in chart in millions for CY ActualsSelect Entire Hierarchies in Power BI Personalize Visuals
Feature Request: Select Entire Hierarchies in Power BI Personalize Visuals Hi Power BI Team, I'd like to suggest an enhancement to Personalize Visuals that allows users to select an entire hierarchy from a semantic model instead of adding each level individually. For example, my semantic model contains this hierarchy: Responsible Division Hierarchy Responsible Division Responsible Cost Center Currently, when users open Personalize this visual, Power BI correctly displays the hierarchy in the field picker. However, selecting the parent hierarchy does not add the complete hierarchy to the visual. Users must expand it and add each level individually in the correct order. Expected Behavior Users should be able to select Responsible Division Hierarchy and have Power BI automatically add the complete hierarchy to the visual, preserving the order defined in the semantic model. Individual hierarchy levels should remain selectable for users who only want a specific field. Why This Matters Personalize Visuals is designed to enable self-service reporting without requiring report editing permissions. Requiring users to manually reconstruct existing hierarchies creates unnecessary friction and assumes they understand the underlying data model. Since the hierarchy is already defined in the semantic model and recognized by the field picker, Power BI should leverage that metadata. Suggested Enhancement Allow users to select either: The parent hierarchy to add the complete hierarchy in its predefined order. An individual hierarchy level to add only that field. This would make Personalize Visuals more intuitive for business users while preserving flexibility for advanced users. Thanks for considering this enhancement!
