New board topics in Microsoft Fabric Community

Dynamic Show/Hide of Legend Images Based on Slicer Selection (Native Power BI Only)

DrRegiste — Wed, 16 Sep 2026 18:49:33 GMT

Hi everyone,

I'm trying to implement a dynamic legend in Power BI based on the selected indicator in a slicer, and I'd like to know if there is a native Power BI solution for this.

Current setup

I have:

A slicer based on Topic[INDICATOR_FR]

A data table OLN_Combined

A field OLN_Combined[IND_INTE] that determines which legend should be displayed

The value of IND_INTE can be:

1 or -1

Business rule

When the selected indicator has:

IND_INTE = 1 or -1

Display Legend 1

Legend 1 contains:

Red = Similar

Blue = Better

Green = Worse

When the selected indicator has:

IND_INTE = 0

Display Legend 2

Legend 2 contains:

Red = Similar

Yellow = Different

What I've tried

Option 1: Shapes / Images in the Selection Pane

I inserted both images using Insert > Image and grouped them in the Selection Pane.

However, I cannot find any way to conditionally control the visibility of these objects using a DAX measure. The available formatting options only include things like:

Background

Border

Shadow

There doesn't appear to be any conditional visibility setting.

Option 2: Buttons containing the images

I also considered using buttons with the images as backgrounds, but I couldn't find a way to dynamically show/hide buttons based on a measure either.

Option 3: Image URL table

I created a table containing the image URLs and categorized the field as Image URL.

This works in a Table visual, and the correct image can be filtered using a measure such as:

ShowImage =

VAR SelectedType =IF(SELECTEDVALUE(OLN_Combined[IND_INTE]) IN { -1, 1 },1,0)

RETURN

IF(MAX(Legends[TypeLegend]) = SelectedType,1,0)

However:

The image is displayed inside a Table visual.

Styling and sizing options are limited.

Ideally, I would like the image to behave like a regular image object on the canvas.

My question

Is there a way, using native Power BI only (no custom visuals), to:

Dynamically show/hide image objects based on a slicer selection and a DAX measure?

Dynamically switch between two image files based on a measure?

Display an Image URL as a standalone image visual (not inside a Table or Matrix)?

If not, what is the recommended native Power BI approach for implementing dynamic legends like this?

Thanks in advance!

Month on Month difference table visual that's sortable

OffColour1972 — Wed, 16 Sep 2026 17:53:55 GMT

Newbie here so bear with me.
I want to create a visual like this

I've done it using a matrix but only the total column is sortable and I need it to be sortable on all columns.
Carrying on with the example, the raw data would have multiple entries each day for each breed of each species.

Any ideas?

Using LookUpValue

greenda4 — Wed, 16 Sep 2026 17:53:13 GMT

Hi,

I created a calculated column and trying to use the LookUpValue function and am receiving the following error

Underlying Error: DataViewMappingError_ConditionNotHierarchicallyRelated

Activity ID: 77181316-2e02-44ea-b104-201ac8d72366

Also, I am getting an error on my visual saying "You are using fields that don't have a supported set of relationships". Not seeing the issue as I have used this LookUpValue function before.

Data Factory definition

db042190 — Wed, 16 Sep 2026 17:52:16 GMT

Hi, as i set up a data movement (etl/elt not versioning) pipeline in fabric, i become more aware of definitions. Am i in "data factory" when adding such a pipeline to my fabric ws or is the notion of data factory more specific to components like data flow gen2 or is data factory none of these things?

E-Commerce Sales Analysis

FarhanJeelani — Wed, 16 Sep 2026 17:47:01 GMT

I've been building an e-commerce analytics report in Power BI covering 48,000 transactions, 4,000 customers and 101 software products (Apr 2024 – Oct 2025). It now has five pages: Executive Summary, Customer Loyalty, Revenue Drivers, Customer Health & Retention, and Refunds & Promotions.

Some of the insights the data surfaced:

Annual plans drive the business. They're 49% of orders but 88% of revenue, and each annual order is worth 10× a monthly one.
Big deals matter most. Orders of 10+ seats are 29% of volume but 70% of revenue.
Revenue is concentrated. 38 of 101 products generate 80% of revenue.
Retention is strong. About 85% of customers keep buying each quarter, but new customer acquisition almost stopped in 2025.
There's a clear win-back list. 492 high-value customers have gone quiet, and together they hold $5.9M of lifetime revenue.
Over half of refunds are preventable. 56% of refunded revenue came from billing errors and duplicate orders.
Promo codes are leaking. Welcome codes were reused on ~5,000 repeat orders ($319K in discounts), and 89% of Black Friday codes were redeemed outside Nov–Dec.

What I used:

DAX for RFM segmentation, cohort retention, like-for-like YoY and Pareto analysis
Deneb (Vega-Lite) for custom visuals: Pareto chart, cohort heatmap, dumbbell chart, refund hotspot matrix
HTML Content visuals for KPI tiles with sparklines and dynamic insight cards
SVG measures to put data bars and bullet charts inside tables
A consistent custom theme, background and typography across every page

Lesson learned: auditing the model before adding visuals paid off. It caught a discount measure totaling $61.9B instead of $1.26M, discount rates above 100%, and tax counted twice in gross revenue.

Feedback welcome!

#PowerBI #DataAnalytics #DAX #Deneb #DataVisualization #Ecommerce #BusinessIntelligence

Advice on number of medallion layers in fabric pipeline

db042190 — Wed, 16 Sep 2026 17:46:10 GMT

Hi , in the prototype im setting up, my fabric pipeline lands the rawest data in the bronze layer and should soon land curated data in the silver using meta data from json to map raw column names to target column names.

i was hoping to take advantage in silver of 1) data typing when target is a table 2) other very common hoops like dealing with duplicates 3) rollback features available in notebooks, i think notebook uses a different term.

As i move forward, i'm noticing that the api's (off the shelf from sap in this case) im using in the bronze layer sometimes wrap/append their own weird things around/to column values...in this case the word "date" with the date value and possibly other non date related characters and possibly a special date format.

I dont want to couple erp specific transform logic (like this date parsing) with more cookie cutter transforms i had planned for the notebook in the silver layer. I think i'd rather add another layer maybe with a metal more valuable than bronze but less valuable than silver, eg copper. Any thoughts, i mean on having 4 layers in a medallion architecture, not the choice of copper?

notebookutils.fs.cp() cannot copy from Lakehouse shortcut to Files in Python notebook

svencken — Wed, 16 Sep 2026 17:39:56 GMT

I've been playing around with notebookutils.fs.cp() and notebookutils.fs.fastcp() in Fabric Python 3.12 notebooks.

This function seems to be unable to copy a file (e.g. PDF) from a SharePoint folder behind a Lakehouse shortcut to a directory in the Lakehouse Files. This produces a AzCopyFailedException.

Somewhat strangely, it is possible to use fs.cp() and fs.fastcp() to copy files from the shortcut to local file storage in the notebook environment and to then copy from this local file storage to the Lakehouse Files.

Has anyone come across a similar issue?

Post is taken down after ~ 1 minute.

dcrow5378 — Wed, 16 Sep 2026 16:40:46 GMT

I have a question about Power BI desktop canvas default layout that has somehow gotten changed. Every time I post my question it is taken down within about a minute.

How to submit a support ticket for Power BI issues.

dcrow5378 — Wed, 16 Sep 2026 16:37:07 GMT

Can anyone please advise how to submit a support ticket for issues with Power BI desktop?
Previously I went through the Power Platform admin center, but this is not working currently.

Question Being Taken Down? I have asked this 3 times and is removed within 1 minute?

dcrow5378 — Wed, 16 Sep 2026 16:19:30 GMT

Default Report Canvas Layout changed and all visuals have changed. Did I inadvertently change a setting?

Desktop Report Canvas Zoomed Out and Visuals Changed

dcrow5378 — Wed, 16 Sep 2026 16:12:32 GMT

Has anyone noticed with the recent update that the report canvas is zoomed out and the visuals have no formatting by default. Did I inadvertently select something that would cause this?

Employee Internal Communication Analytics | DataFlip

dataflip — Wed, 16 Sep 2026 16:12:05 GMT

Poor internal communication can create information gaps, disconnected teams, and slower decisions. When communication data is spread across different reports, leaders often struggle to understand how teams engage and collaborate. This dashboard brings internal communication data into one clear view, helping organizations improve engagement and workplace collaboration.

Business Impact:

This dashboard helps organizations:

Track email engagement, open rates, and sentiment
Understand communication patterns across departments and seniority levels
Identify communication trends by department, topic, and day
Monitor after-hours and weekend communication activity
Identify communication gaps and collaboration silos
Support better employee engagement and workforce decisions
Reduce manual reporting with centralized communication KPIs

It helps leaders understand communication patterns and build a more connected, engaged, and productive workplace.

Who Can Use This Template:

HR and People Operations Teams
Internal Communications Leaders
Department Heads and Senior Managers
Employee Experience Teams
Executive Leadership Teams

Discover more insight-driven templates built for real business decisions. Visit DataFlip

Heat or contour map visual

am_nr — Wed, 16 Sep 2026 16:06:53 GMT

Anyone have a nice solution for a heat map visual in Power BI? I find the heatmap settings on the default Azure Maps to be a bit lacking as it doesn't really reflect the density of points in an area. There used to be a very nice free visual literally called "Heatmap" but now you've to pay for a Bing Maps Enterprise key to use it. The "Data Map" visual also has a nice enough heatmap setting which I used to use with an Open Street Map base layer but now OSM keeps blocking access in PowerBI citing the tile usage policy.

Looking for suggestions, ideally free, or any indication that there's plans to improve the Azure map heatmap option.

Desktop Report Zoomed out and Visuals Changed

dcrow5378 — Wed, 16 Sep 2026 16:03:47 GMT

Has anyone else noticed with the latest update that the desktop report layout is zoomed out and the visuals have no formatting applied by default. Did I inadvertently select an option that would change the default view/layout? Notice the card visual is sideways? The default zoom I've seen is around 60-80%.

Unable to Access Microsoft Fabric Trial

surajnimse — Wed, 16 Sep 2026 15:18:23 GMT

Hello Support Team,

I am facing an issue with the Microsoft Fabric trial on my tenant (ZOHOMAIL.IN).

- **Issue faced:**

I created a new account and attempted to start the Fabric trial. However, instead of the Fabric trial capacity being provisioned, only a **Power BI Pro trial** was activated. My goal was to use the Fabric trial to create and test Lakehouse functionality.

- **Steps taken to fix:**

1. I tried creating a Lakehouse, but received an error message related to trial capacity.

2. I attempted multiple troubleshooting steps, including checking the Admin Portal and workspace assignment options, but none resolved the issue.

3. Finally, I cancelled the free trial, hoping to restart it correctly.

- **Current issue still existing:**

After cancellation, I am unable to restart the trial. The **Start trial** option is no longer visible in the Account Manager panel. At present, neither the Fabric trial nor the Power BI Pro trial is available for my tenant. This prevents me from testing Fabric features such as Lakehouse creation.

Could you please help reinstate the Fabric trial for my tenant, or confirm if the only option is to create a new tenant to access the trial again?

Thank you for your assistance.

Best regards,

Suraj Nimse

Matrix with stacked bar chart and with column measures

ldwf — Wed, 16 Sep 2026 15:18:19 GMT

I am trying to build a matrix that will have a stacked bar chart as a column, together with two other columns (i.e, measures). See screenshot. The red/yellow/green colors are defined by a category field that is already defined in the model. Is a matrix like this even possible? Do I need to use svg codes inside of DAX measures?

Can I get confirmation from a PBI Admin that this is up to date?

grayscg — Wed, 16 Sep 2026 15:06:14 GMT

I have been given Power BI admin access recently by my organization. I am trying to find out how to create apps and pipelines from workspaces. I see this documention by microsoft:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-create-distribute-apps

But I do not see those "create app" and "create pipeline" buttons shown. Is this documentation out of date and there is another way to do this? Or do I maybe not actually have the needed access yet?

Thank you

FABRIC REST API Connections - Create Connection

Charline_74 — Wed, 16 Sep 2026 14:29:45 GMT

Does anyone know how to run this API via a PowerShell script to create a SQL Server cloud connection for a semantic model using Service Principal authentication?

Here's what I have so far:

Invoke-PowerBIRestMethod -Url "https://api.fabric.microsoft.com/v1/connections" -Method Post -Body $body

But I don't understand how to construct the body

Thanks in Advance,

Charline

Power BI Service Home – Recent items sometimes not showing

manoj_0911 — Wed, 16 Sep 2026 12:32:43 GMT

Hi Team,

I'm facing an intermittent issue with the Power BI Service Home page.

Normally, under Home → Recent, I can see the reports and workspaces that I recently opened, along with the Opened time and Location.

However, sometimes the Recent section does not show the recently opened reports/items, even though I have opened reports normally.

Issue:
The Recent list is sometimes empty/not populated or doesn't appear to update.

Environment:

Power BI Service (Web)
Browser: Microsoft Edge / Google Chrome
Issue is intermittent
Reports are located in Power BI Workspaces

Has anyone else experienced this issue with the Power BI Service Home → Recent section?

Is this related to a Power BI Service issue, browser/session/cache issue, or some limitation with how the Recent list is populated?

Any information on how the Recent list is generated and how to troubleshoot this would be appreciated.

I'd also attach the screenshot you sent me and circle the Recent section.

Best Practice for CICD Deployment Connections in Fabric UDFs?

david_avgarcia — Wed, 16 Sep 2026 12:21:11 GMT

I recently faced a challenge with Fabric User Data Functions where environment-specific SQL connections need to be handled across Test and Production deployments (deployment pipelines do not update the connectionId )

My current approach is to register both connections in the UDF and use a Fabric variable to determine which one to use at runtime:

@udf.connection(argName="testsqlDB", alias="testsqldb") @udf.connection(argName="prodsqlDB", alias="prodsqldb") @udf.connection(argName="envConfig", alias="environmentConf") @udf.function() def FO_Subscribe_Unsubscribe(testsqlDB: fn.FabricSqlConnection, prodsqlDB: fn.FabricSqlConnection, envConfig: fn.FabricVariablesClient, IsUserSubscribed: int, UserEmail: str, FundingOpportunityID: str, FundingOpportunity: str) -> str: # Step 1: call stored procedure that inserts or delete rows from the subscription table try: connection = get_sql_connection(envConfig,testsqlDB,prodsqlDB) cursor = connection.cursor()

This seems to work well for now, although ideally Fabric would support deployment-time connection binding so that only a single logical connection alias is needed in the code.

I'm curious how others are handling CI/CD for UDF connections:

Are you using a similar pattern?
Is the deployment-time connection binding for UDF planned for the future?