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

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.

Reply
Anonymous
Not applicable

100% stacked bar chart with 0.XXK%

 

Hi All,

 

i'm trying to use the 100% stacked bar chart for 1 of my visual but when i'm turning on the Data label, it is showing a 0.04k% intsead of 40%. Appreciate your heklp on this.

 

100% Stacked Bar.jpg

1 ACCEPTED SOLUTION
v-gizhi-msft
Community Support
Community Support

Hi,

 

Please try to change its data format to 'Percentage' instead of 'Currency', see this:

1.jpg

 

Best Regards,

Giotto

 

View solution in original post

6 REPLIES 6
v-gizhi-msft
Community Support
Community Support

Hi,

 

Please try to change its data format to 'Percentage' instead of 'Currency', see this:

1.jpg

 

Best Regards,

Giotto

 

nandukrishnavs
Super User
Super User

@Anonymous 

Try to change its format as a decimal number and see how it is working.


Regards,
Nandu Krishna

Anonymous
Not applicable

@nandukrishnavs , just tried but the result is the same.

@Anonymous  Hmm, Not sure why it is happening. I tried to replicate your issue. But I couldn't. 

 

Alternatively, you can calculate the percentage value and use it in the measure. 


Regards,
Nandu Krishna

Greg_Deckler
Super User
Super User

That's really odd @Anonymous I've never seen that. Try the Formatting pane, under Values there is generally a setting for display units. Try changing that to None instead of Auto or whatever it is set to right now.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler , tried by changing it to either 2/4 but the result is same.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.