How to show the % value on Top of Stacked Column chart

[ssamal]

I have Total case count and Open Cases count, I want to show % of Open Cases on Top of the stacked column chart as above. Currently I have added a line chart but position of % value should be exactly on top of the Column, Is that feasible or a workaround for this? Thanks

[v-echaithra]

Hi @ssamal,

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?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra.

[v-echaithra]

Hi @ssamal ,

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?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra.

[v-echaithra]

Hi @ssamal ,

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?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra.

[v-echaithra · Accepted solution]

Hi @ssamal ,

Create a Measure to Calculate % Open Cases:

% Open Cases =
DIVIDE([Open Cases], [Total Cases])

Create a Measure to Plot a Transparent Bar at the Top:

Top Marker = [Total Cases]

This will be used just to anchor the % label at the top of each column.

Create Another Measure to Show the % as a Data Label:

% Label =
FORMAT([% Open Cases], "0%")

Use a Stacked Column Chart (not combo):

Axis: Category (like Month or User, etc.)
Values:
Open Cases
Closed Cases
Top Marker

Format the Top Marker bar:
Go to Data colors → Set Top Marker to transparent (100% opacity) or the same as background
Enable Data labels
Turn on data labels only for Top Marker
In Customize series, choose Top Marker → set Label to show Value, and optionally override with % Label via tooltips.

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra.

[amitchandak]

@ssamal , Use Stacked Line visual. Display Label for line and Make Line Width =0

[ssamal]

Thanks @amitchandak . The screenshot I shared is nothing but a Stacked column / Line visual but you can see how the % figures not exactly on top of each column.

[GrowthNatives]

Hi @ssamal ,

I think, You’re trying to show % of Open Cases directly on top of the stacked column—not just using a line chart, but aligned perfectly with the top of the column. That’s a very common need in Power BI, but yeah, it can be a bit tricky because Power BI doesn’t let you dynamically place a label above a column natively unless you hack it a little 🙂.

We think you want something like this.

• Column (Total Cases, Stacked: Open + Closed)

• On top of the column: % Open Cases value, perfectly aligned

You can use the following workarounds::

1. Create your % Open Cases measure:

DAX

% Open Cases = 
DIVIDE([Open Cases], [Total Cases], 0)

Make sure [Open Cases] and [Total Cases] work for each axis category (date or whatever grouping you’re using).

2. Use a Combo Chart:

• Add Total Cases to the Column Values (stacked columns).

• Add % Open Cases to the Line Values.

3. Make the Line Invisible (but keep the markers):

• Format the line:

  • Line color → Transparent (or same as background).

  • Marker → Turn ON.

  • Marker shape → Choose something clean.

  • Marker color → Make this visible (usually black or same as data label).

  • Data Label for Line → ON, position Above.

This gives the illusion that your % label is sitting perfectly on top of your stacked column.

** Plus ::

You can also add the % Open Cases to the Tooltips so that it's visible when hovering over the columns.


⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀

[ssamal]

Thanks @GrowthNatives . Somehow managed to adjust by keeping one Stacked column chart and another Line chart. But still %Open Cases not on exactly on top of the columns 

[GrowthNatives]

Hi @ssamal , 

thanks for the precise reply and reaching out, here is some approach that you can try at your end.
🔧 Some more precise workaround using just one chart (no stacking needed):

✅ Use a Combo Chart (Line and Stacked Column) with Smart Formatting:

1. Use One Visual – Combo Chart:

   • Add:

     • Stacked column values: Total Cases broken into Open and Closed.

     • Line value: % Open Cases measure.

2. Match the Axis Ranges (IMPORTANT):

   • To fix misalignment, you need the Primary and Secondary Y-axis to match.

   • Manually set the Y-axis bounds for both:

     • Right-click on each axis (Y-axis and secondary Y-axis from the line chart).

     • Set minimum to 0 and maximum to the same value (like 100 or your data's max).

   • This ensures that the % line aligns with the actual column top, because the scaling matches.

3. Turn Off the Line (Keep Labels):

   • Set line color to transparent or white.

   • Keep marker ON.

   • Turn on Data Labels for Line → Position: Above.

---

✍️ Optional if you can add :

• Turn off the data label for the column (if you only want to show %).

• Or keep both, depending on your use case.
  
  If you liked our solution, please give it a thumbs Up 👍, happy analysing..