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

How do I show my value as a percentage in a visual?

Hi All,

 

I have a set of data in Excel already formatted as percentages (2 decimal point) which sums to 100%, see table below.

 

 Age profile - 2015 to present (%)Age profile - 2005 to 2014 (%)Age profile - 1995 to 2004 (%)Age profile - 1985 to 1994 (%)Age profile - 1975 to 1984 (%)Age profile - 1965 to 1974 (%)Age profile - 1955 to 1964 (%)Age profile - 1948 to 1954 (%)Age profile - pre 1948 (%)
BEDFORD0.00%3.57%17.86%14.29%17.86%21.43%14.29%3.57%7.13%

 

In my query editor on Power BI, the figures are shown as below.

 

0.00000.03570.17860.14290.17860.21430.14290.03570.0713

 

and when I create a stacked bar visualisation, the percentages are not represented but only as a decimal.

 

Visual.jpg

 

How can I show these values as a percentage out of 100%, including on the axis. I have tried changing the data type in the query editor but still to no success.

 

Help would be appreciated.

 

Thanks

 

Sun1

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Try set the measure as Type: Decimal, SubType: Percentage

 

percentage.png

View solution in original post

9 REPLIES 9
grandhi20
Frequent Visitor

Hello everyone

 

Does this work with Power BI Desktop version?

 

I have October Update version of Power BI Desktop. I am trying display values as percentage in a bar chart. But somehow "Formatting" section under Modeling is grayed out to me.

 

I am getting data from a SQL server Analysis server (I dont know if it matters)

 

Please help me. Thanks in advance

 

@grandhi20

Did you select column before viewing the Modeling section. Without selecting any column from the fields section, formatting will be grayed out.

Thanks for responding. 

 

Yes I selected the bar chart which I want to change from values to percentage. Also I tried by changing to table or other visuals if Formatting will be available. But no luck

@grandhi20

It's not about selecting the visuals.

Capture.PNG

Select a column and then check with modeling. 

You can see in the image, I selected BudgetMSPricing and gives me Formatting options.

Its strange. I have tried selecting column as well. But no luck.

 

Its strange. Formatting is always grayed out irrespective of which column I selected or which Visual I selected

 

Thanks for responding

@grandhi20

Try closing you file and re-open. can you share your file..?

Thanks a lot friend. You saved my effort.

Infact It was neither getting activated for me as well. Because I was just clicking on the fields to get it selected.

But your picture made it easy. I understood I was not selecting the field but just clicking it.

 

This saved my half day's effort.

Looking forward to more of your useful tips.

Thanks Again

Anonymous
Not applicable

Try set the measure as Type: Decimal, SubType: Percentage

 

percentage.png

View solution in original post

Sun1
Frequent Visitor

Thanks Cabelo!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors