Stacked column chart legend labels become “(Blank)” after changing series colors
I’m experiencing an issue with a native stacked column chart in Power BI Desktop. I updated Desktop yesterday, September 29, 2026. The chart uses: X-axis: Year/week. Y-axis: A measure calculating overdue balances at the end of each week. Legend: Five aging categories from a disconnected table: 0–6, 7–30, 31–60, 61–90, and 91+ days. After manually changing individual series colors, all five category names appear as “(Blank)” in the series selector in the formatting pane. The chart legend also displays “(Blank)”, although the columns still contain five colored segments. I have tested the following: Verified through DAX queries that all five category names are populated, including under the selected business-category filter. Disabled the slicer’s interaction with the chart; the issue persisted. Saved, closed, and reopened Desktop; the issue persisted. Copied the affected chart to a test page; the issue persisted. Created a fresh chart, which initially worked, but the issue returned after copying it to the intended report page. “Reset to default” restores the correct legend labels, but removes the custom formatting. Expected behavior: changing series colors should preserve the category names in both the legend and the formatting pane. Could you investigate whether this is a defect in how custom series formatting is stored or rendered? I can provide screenshots and the exact Desktop build number if needed. Thank you.
Retail/SME banking analytics on Azure: consolidate into Fabric or keep Databricks and Azure ML?
We worked on an Azure-based analytics setup for a retail and SME banking platform. Data comes from core banking systems, transaction platforms, CRM, risk engines, payment gateways and external credit bureau data. The current architecture is: Azure Data Factory + Databricks for ingestion, transformation and validation Azure Data Lake with raw, processed and curated layers, for batch and near real-time analytics Power BI for fraud alerts, credit exposure, portfolio performance and compliance reporting Azure Machine Learning for fraud detection, credit scoring, churn prediction and forecasting Event-driven workflows for data refreshes, alerting, model retraining and regulatory reporting Purview, RBAC, encryption, audit trails and lineage for FCA/GDPR requirements Volume is around 8.5-9 million transactions per day on the fraud side. If you were designing this, would you move most of it into Fabric (OneLake + Lakehouse, Data Factory/Dataflows, Power BI with Direct Lake, and Fabric's ML capabilities)? Or would you keep Databricks and Azure ML as separate components for a regulated banking workload at this scale? I'm particularly interested in how you'd handle the ML/model retraining side and governance across Fabric and Purview.
Dynamic axis label: show real name only for one company, others "Anonymous"
I have a bar chart (ranking) with one bar per company. All companies should stay visible, but the labels on the axis should work like this: The company of the current user (identified via USERPRINCIPALNAME() and a mapping table Company ↔ E-Mail) shows its real name All other companies show as "Anonymous" (or a neutral label) Example: Bar Label for user of Company 12 1 Anonymous 2 Anonymous 3 Company 12 4 Anonymous The problem: An axis field must be a column, but the logic depends on the current user, so I can only build it as a measure: DAX Firma Anzeige = VAR _Own = [Eigene Firma] // LOOKUPVALUE on the mapping table via USERPRINCIPALNAME() VAR _Current = SELECTEDVALUE( Fakten[Firma] ) RETURN IF( _Current = _Own, _Current, "Anonymous" ) A calculated column doesn't work either, because it is only calculated at refresh time and not per user. My current workaround: I show an index/letter on the axis and a separate small table that maps the letter to the user's company. My client finds this too complicated. Question: Is there any way to show a user-dependent label (real name vs. "Anonymous") directly on the axis of a bar chart? For example with field parameters, dynamic format strings, visual calculations, or a different table design? Or is there a better pattern for this scenario? Thanks in advance!
Power BI Service refresh error with Web.Contents and SharePoint
Hi everyone, we are experiencing a refresh error in the Power BI Service. The refresh works successfully in Power BI Desktop. Our workspace contains several reports that use Excel files stored in SharePoint. The files are accessed through Web.Contents. This setup has worked for approximately three years and still works for most reports. However, one report fails during every refresh with the following error: DM_GWPipeline_Gateway_MashupDataAccessError Microsoft.Data.Mashup.ErrorCode: 10122 Reason: DataSource.Error The error refers to a SharePoint URL ending in: /_api/contextinfo This suffix is not part of the actual URL used in the query. The same Excel file is also used by another report with identical queries and authentication, and that report refreshes successfully. This suggests that the file itself is probably not the root cause. We have already tried the following: Replacing Web.Contents with the SharePoint connector Re-authenticating the connections Adjusting the privacy levels for the cloud connections Verifying the permissions on the SharePoint file and folder We also have a gateway configured for on-premises data sources such as SQL Server. The SharePoint connections use cloud credentials and should not use the gateway. Has anyone experienced this error only in the Power BI Service while Power BI Desktop works correctly? Is there an explanation for why the same SharePoint file works in one report but fails in another? Thanks in advance for any advice.
User created Sharepoint Calendar as default view, now I can't find the list?
Hello! Basically, I used Get Data --> sharepoint online list --> 2026 Events Calendar Got all the fields. EZ PZ. Since then, they created a Calendar view, which is nice, they can edit the records right there and it's now the default view. Because of this, now when I go to the dataset I created last week, it fails and defaults to the Calendar View, which only uses 4 columns of the 25 ish in allitems. However, I can't find that list anywhere except those 4 columns. I did find the URL, but that doesnt seem to help. I was considering using the API, but it is a last resort. Any thoughts?
Support needed with the calculated column
Using Power Query, I have loaded the data to the data model. I need support with a couple of questions How can I create a cumulative calculated column For the Qty at SKU, Date Level, and Sorted by Date Date SKU QTY 4/26/2025 B 54 4/4/2025 C 12 1/23/2025 A 57 5/18/2025 B 61 1/23/2025 C 79 3/20/2025 B 37 1/3/2025 C 86 4/27/2025 C 67 3/14/2025 A 93 1/3/2025 B 51 1/3/2025 A 11 2/17/2025 A 95 2/25/2025 C 32 4/5/2025 A 25 2/11/2025 B 76Agile plan for Power BI Project
i need to know typical sprint plan for Power BI Project which includes 5 Dashboards with Azure Databricks as database, duration is 6 months, 2 weeks per sprint is considered How i should decide on Epics, Features , Strories and Tasks ? what should be their names What need to be considered in each sprint demo? example KPIs, wireframes etc Do i need to create one story per dashboard? how I would decide on story points for each story? How i should handle changing requirements ?
