Forum Discussion
100% stacked chart - replace % with actual value
In the following chart can I replace % with actual numbers?
Thanks
10 Replies
- AllisonKennedy
Community Champion
Markzolotoy You could do this with custom visuals or you could try creating your own custom visual using Charticulator.
- Markzolotoy
Impactful Individual
Which custom visual do you have in mind?
- AnonymousNot applicable
Hi Markzolotoy ,
Is the following result what you want?
Or you just want to remove the sign of "%" and keep the numbers before the Percentage?
Best Regards,
Yuna
- Markzolotoy
Impactful Individual
I want what's shown on the right side: actual values.
- AnonymousNot applicable
Hi Markzolotoy ,
You can use the "Stacked column chart" visual instead of the "100% Stacked column chart" visual.
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
And how would I keep all columns at the same height?
- AnonymousNot 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.
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.
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.
- AnonymousNot 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
- Markzolotoy
Impactful Individual
Of course it is still there.
- AnonymousNot applicable
Hi Markzolotoy ,
Thanks for your reply. Power BI does not currently support this feature.
You can vote your ideas here.
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.