cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sumodjena Frequent Visitor
Frequent Visitor

Showing percentage in do nut and pie chart

How to show percentage in Do nut  and pie chart in power BI.This option is available in excel but i am not able to found in power BI

3 REPLIES 3
B129 Member
Member

Re: Showing percentage in do nut and pie chart

Hi @sumodjena,

 

   you have to :

 

1) select the field

 

2) in the "Data tools - Modelling" you must have Data type = Whole Number

dt.png

 

3) Then you can change the "Format" in Percentage

p.s. You can also click the Percentage button to apply that format.

 

Let me know if it works.

 

#I'M Not An Expert#

Highlighted
Christofer Regular Visitor
Regular Visitor

Re: Showing percentage in do nut and pie chart

Hi!

 

Quick note, a decimal data type works aswell!

B129 Member
Member

Re: Showing percentage in do nut and pie chart

Thanks @Christofer, my bad because also the "Fixed Decimal Number" works.