cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How do I edit the decimal point on show value as Percent of Column Total?

Hi,

 

I would like to know on how to edit the decimal point when I am using "show value as Percent of Column Total"?

Please advise.

 

Thank you.

Rudy

Percent of Column Total.JPG

1 ACCEPTED SOLUTION
v-haibl-msft
Microsoft
Microsoft

@Anonymous

 

We cannot edit the decimal point for this built-in calculation. As a workaround, we can create another measure to do the same calculation, then edit the decimal point in Modeling - Formatting as following screenshot.

 

How do I edit the decimal point on show value as Percent of Column Total_1.jpg

 

Best Regards,
Herbert

View solution in original post

7 REPLIES 7
Subhraz
Frequent Visitor

Hi,

If the percent value is shown on a chart, Power BI allows us to format the no. of decimal places required.

Select the visual, Go to Format/Data labels -> then update Visual decimal places as needed.

Subhraz_0-1629965700491.png

Subhraz_0-1629965387744.png

Subhraz_1-1629965803592.png

 

Thanks,

Subhrajit

Zhanar
Advocate I
Advocate I

Here is how to format decimal places on Show Value As

1. Select your visual

2. On the Visualization pane, Goto Format/Field Formatting/ Value decimal places - INPUT 0 OR AS MANY PLACES YOU NEED AND DONE

Anonymous
Not applicable

 

Hello, 

That works for other visuals, but when I am using the Matrix table it is not working. i click the value decimal places, but it only says "Auto"

 

ivargaspr_0-1601309221396.png

 

v-haibl-msft
Microsoft
Microsoft

@Anonymous

 

We cannot edit the decimal point for this built-in calculation. As a workaround, we can create another measure to do the same calculation, then edit the decimal point in Modeling - Formatting as following screenshot.

 

How do I edit the decimal point on show value as Percent of Column Total_1.jpg

 

Best Regards,
Herbert

This is really a poor solution.  If a new column, field, or measure is created, then the user loses the ability to have the values categorically broken out using particular built-in visualizations.  Come on guys.  If you are going to build in built-in calculations, why wouldn't MS suspect that people are going to want to format such?   #greatjobbilly

 

Honestly I wouldn't expect anything else.  Any idea on when this will be fixed? 

 

Mark

omitche2
Frequent Visitor

In addition, if you have a hierarchy with two levels, Region and Sales Rep, you can't drill down into the region and have that calc you referenced recalculate the % of total like the Show Value As option does.  Does anyone have the dax behind this Show Value as a percent of column total?

Anonymous
Not applicable

Thank you Herbert Smiley Very Happy@v-haibl-msft

 

 

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors