Dynamic banding in Stacked Column Chart via user input threshold values as comma-separated list

Unfortunately, this isn't supported by the native Power BI Stacked Column Chart due to how the visual engine works.

The key limitation is that the Legend field must be bound to a physical column in the semantic model. Power BI determines the legend categories before DAX measures are evaluated, so a measure cannot dynamically create a varying number of legend categories at runtime.

Specifically:

• ❌ DAX cannot parse a user-entered comma-separated string and dynamically create N+1 legend categories.

• ❌ Measures cannot return a dynamic set of categories for the Legend bucket.

• ❌ Field Parameters can switch between existing fields, but they cannot generate new categories dynamically.

Possible alternatives

1. Fixed maximum number of thresholds (Most practical)

Create a predefined number of threshold parameters (e.g., 5 or 10) and corresponding band logic. While users won't have unlimited thresholds, this approach works well for most business scenarios.

2. Use Deneb (Recommended for full flexibility)

If truly dynamic banding is required, Deneb (Vega-Lite) is probably the best option.

With Deneb, you can:

• Accept a user-defined threshold table (instead of a comma-separated text string).

• Dynamically calculate the band for each row.

• Render a stacked chart without relying on the native Legend limitations.

• Support an arbitrary number of bands, limited only by the data provided.

3. Store thresholds in a table instead of a text string

Instead of entering:

86,111,150,250

allow users to maintain a Thresholds table (via Power Apps, Fabric, SQL, SharePoint, Excel, etc.):

Threshold

Your ETL or Power Query process can then:

• Sort the thresholds.

• Generate the ranges.

• Assign each order to a band before it reaches the visual.

This is much more maintainable than parsing free-form text.

4. Perform the banding upstream

If the thresholds need to change frequently, consider moving the logic to:

• Fabric Notebook

• Dataflow Gen2

• SQL stored procedure

• Azure Function/API

These technologies can parse the threshold list, generate dynamic bands, and return a dataset that Power BI can visualize.

Recommendation

If the requirement is true runtime, unlimited dynamic thresholds entered by the user, there isn't a supported DAX-only solution with the native stacked column chart.

The most scalable approaches are:

• Deneb for custom visualization and dynamic encoding.

• Threshold table + ETL/Dataflow for enterprise-grade implementations.

I'd be interested to hear if anyone has implemented a similar requirement using Deneb, Charticulator, or another custom visual while maintaining good report performance.

For more information:

• Deneb custom visual: https://deneb-viz.github.io/

• Field Parameters in Power BI: https://learn.microsoft.com/power-bi/create-reports/power-bi-field-parameters

• What-if parameters: https://learn.microsoft.com/power-bi/transform-model/desktop-what-if

💡 Helpful? Give a Kudos 👍 — keep the community growing.

✅ Solved your issue? Mark this as the Accepted Solution ✔️

Best regards, Prince Singh | Data Science & Microsoft Fabric Enthusiast

I am not sure if wen can do this by inputting the data. Maybe we can select or choose the data to set up the scope. could you pls provide some sample data and expected output

Sure, here is the sample data.

Base Table: OrdersFact

Following is the description for columns in above table:

Visual Mapping:

We are looking to implement a 100% Stacked Column Chart where:

• X-Axis: OrdersFact[OrderDate] (grouped by Year or Month)

• Y-Axis: COUNT(OrdersFact[OrderId]) (expressed as 100% relative percentage stacked composition)

• Legend (Bands): Segmented by OrdersFact[Price] into dynamic bands.

Expected Dynamic Behavior:

• Users specify price thresholds in a comma-separated list form: `86, 111`

• The visual segments the total order count into N+1 dynamic price ranges (Here, N = 2):

  1. Band 1: min < 86

  2. Band 2:  87 - 110

  3. Band 3:  111 - max

• Bars dynamically recalculate and re-stack whenever threshold parameters change.

The objective is to allow end-users to provide runtime threshold inputs without hardcoding or capping the number of available dynamic thresholds. Entering N comma-separated dynamic values (e.g., 86, 111) should dynamically generate N+1 stacked bands on the chart (e.g., Band 1: < 86, Band 2: 86 - 111, Band 3: > 111).

Expected Visual:

Approaches Explored:

We have evaluated standard Power BI methods, but each carries significant architectural limitations for this specific setup:

1. Numeric Range (What-If) Parameters:

Limitation: Requires creating a fixed, finite number of dynamic parameter slicers in advance (e.g., T1, T2, T3). This caps the dynamic capabilities and does not scale if a user needs to input 5 or 10 dynamic boundaries at runtime.

2. Predefined Threshold Combinations:

Limitation: Requires hardcoding combination mapping tables into the data model. It removes true ad-hoc runtime flexibility for the user.

Since these standard approaches have trade-offs, I am looking for alternative architectural patterns or workarounds that can achieve this functionality.

Thankyou danextian , Prince0011 , ryan_mayu   for Addressing the issue.

Hi SanketMendhe  ,

Thank you for reaching out to Microsoft Fabric Community Forum,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

Regards,

Chaithanya

Hi @SanketMendhe  ,

Thank you for reaching out to Microsoft Fabric Community Forum,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

Regards,

Chaithanya