Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Markzolotoy
Impactful Individual
Impactful Individual

100% stacked chart - replace % with actual value

In the following chart can I replace % with actual numbers?

Markzolotoy_0-1615633831285.png

 

Thanks

10 REPLIES 10
Anonymous
Not applicable

Hi @Markzolotoy ,

 

Thanks for your reply. Power BI does not currently support this feature.

You can vote your ideas here.

Ideas (powerbi.com)

 

Hope that's what you were looking for.

Best Regards,

Yuna

 

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

Markzolotoy
Impactful Individual
Impactful Individual

Of course it is still there.

Anonymous
Not applicable

Hi @Markzolotoy ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

 

 

Best Regards,

Yuna

Anonymous
Not applicable

Hi @Markzolotoy ,

 

I doubt if it is possible because the Y-axis value of 100% Stacked Column chart is the percentage. 

You can just hover the mouse arrow on the chart, and the corresponding real value will appear.

v-yuaj-msft_0-1615948528124.png

There is seemly no direct method to achieve it for 100% stacked chart.

But you may try to use measure and add it to tooltip as below post.

https://community.powerbi.com/t5/Desktop/Display-number-and-percentage-at-same-time-in-bar-chart/td-...

 

More info about 100% Stacked Column chart

 

Hope that's what you were looking for.

Best Regards,

Yuna

 

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

Anonymous
Not applicable

Hi @Markzolotoy ,

 

You can use the "Stacked column chart" visual instead of the "100% Stacked column chart" visual.

v-yuaj-msft_0-1615856858984.png

Hope that's what you were looking for.

Best Regards,

Yuna

 

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

And how would I keep all columns at the same height?

Anonymous
Not applicable

Hi @Markzolotoy ,

 

Is the following result what you want?

v-yuaj-msft_0-1615801376582.png

Or you just want to remove the sign of "%" and keep the numbers before the Percentage?

 

Best Regards,

Yuna

I want what's shown on the right side: actual values.

Markzolotoy
Impactful Individual
Impactful Individual

Which custom visual do you have in mind?

AllisonKennedy
Super User
Super User

@Markzolotoy You could do this with custom visuals or you could try creating your own custom visual using Charticulator


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors