Stacked Column Chart - Transparency

[bdpr_95]

Does anyone know if it's possible in stacked column charts to make one column have a different level of transparency in terms of colors?

[V-yubandi-msft]

Hi @bdpr_95 ,

Thank you for contacting the Fabric Community. As mentioned by @Ritaf1983 and @rohit1991.  Power BI does not currently allow transparency settings for individual columns or segments in a stacked column chart. Transparency can only be applied at the series level, not to specific bars or data points.

The alternatives suggested by Ritaf1983 and rohit1991 are good options to achieve a similar visual effect, so you may want to consider those approaches.

Thanks to @Ritaf1983 and @rohit1991  for your helpful responses.

Best regards,
Yugandhar

[Ritaf1983 · Accepted solution]

Hi  @bdpr_95 

 With the default Power BI UI, it’s not possible to apply different transparency levels to specific parts of a stacked column.

However, you can simulate this using DAX logic. Here's the approach:

Create a separate measure per color using logic like this:

G_measure = CALCULATE(SUM('Table'[value]), 'Table'[color category] = "Green")
b_measure = CALCULATE(SUM('Table'[value]), 'Table'[color category] = "Blue")
Y_measure = CALCULATE(SUM('Table'[value]), 'Table'[color category] = "Yellow")
Transparent = 4 // or dynamic if needed

Create a supporting table for the legend (e.g. using “Enter Data”) with a [Color] column and an [Order] column to control sort order. Do not assign a name to the transparent color so it doesn’t appear in the legend.

 

Set the [Color] column to be sorted by [Order].

Build a dynamic measure based on the selected legend item and the X-axis category:

dynamic_m =

var color = SELECTEDVALUE(colors[Color])

RETURN

if (color= "" && max('Table'[value category])= "b",[Tansparent],

SWITCH(color,

"Blue", [b_measure],

"Green" ,[G_measure],

"Yellow" , [Y_measure], 

blank()))

Use this dynamic_m measure in a stacked column chart with the Color column from your custom table as the legend. 

You can now set the transparency for the unnamed "transparent" series via the format pane

.Result :

The with the example is attached

P.S
Important UX note: Stacked charts can already be hard to interpret, especially when segment sizes are close. Adding transparency makes the distinction even less clear. If your visual is used for analytical insights or comparisons, this could reduce its effectiveness.

More on this topic in my blog post here:
https://www.madeiradata.com/post/home-experiments-and-stacked-bar-graphs

If you'd like feedback on your actual business need or logic behind the visual, feel free to open a separate post and we can suggest better alternatives based on that.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[rohit1991]

Hi @bdpr_95 

As of now, Power BI doesn’t support setting transparency (opacity) for individual columns or segments within a stacked column chart. Transparency settings apply at the series level (based on legend/category), not per individual bar or data point.

There are some workaround as below

• You can adjust color shades using conditional formatting and Field value logic, but this changes color tone not true transparency.

• For full control over per-bar opacity, you’d need to use a custom visual like Deneb (Vega-Lite) or Charticulator.