Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good Afternoon,
How can I set the label to show the # instead of the % in this 100% stacked column chart?
Using the first column as an example, display 105 instead of 82%, 14 instead of 11%, and 9 instead of 7%
(or even displaying both the # and the % would be fine)
If the standard "100% stacked column chart" cannot do this. Is there a different 100% stacked column chart that I can download that can do this?
Thanks,
J
Solved! Go to Solution.
Hi @bpnjmc1 ,
Please try the custom visual 100% Stacked Column chart with value label (Not %) .
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think I found the solution to this:
Under the "Format Visual" button, turn on data labels. Under data labels, go to values, and add a custom label (turn it on). For the field select your measure. This worked for me.
So, for my own use case I came up with the following measure:
Value and Percent =
CONCATENATE(COUNT(Table1[ID])," ("&FORMAT('New Measures'[% of Total],"0.0%")&")")
Hi @bpnjmc1 ,
Please try the custom visual 100% Stacked Column chart with value label (Not %) .
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
My sincere appologies, I thought I had replied. Thank you for your solution. Unfortunately, our organization hasn't purchased any subscriptions to visuals that do not come with Power BI Desktop. I can only add in visuals that are free.
Based on your response, it sounds like Power BI cannot do this without purchasing additional subscriptions. Hopefully Microsoft will provide this ability in the future. In the meantime, I will have to continue to produce this particular chart in Excel and distribute it via email.
Thank you,
J
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
104 | |
77 | |
71 | |
50 |
User | Count |
---|---|
146 | |
107 | |
106 | |
89 | |
65 |