cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wingmiester
New Member

Fomatting as percentage without measures or calc columns

Hi,

 

I have just started usiing Power BI and trying to create some simple charts. I have used SSRS previously do acheive a a similar thing.

 

I am using a SQL data source, which does appear to have some limitations, but I have got around that. However I seem to have a very simple problem which I can't resolve without using a measure or calculated column.

 

I have a Line and Stacked Column Chart. The line value is a decimal but I just want to show a '%' after the value. I don't want to be changing the column type in the query or anything like that, just want to show the '%' symbol after the number on my graph.

 Graph.PNG

 

Its probably my vast inexperience with Power BI but can someone please help?

 

Thanks,

 

Kevin

1 ACCEPTED SOLUTION
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @wingmiester,


 

In Power BI, there is no option for us to add the '%' symbol after the number directly without creating formulas. If you don't want to create the measure or calculated column,  you could create a custom column in Query Editor like below. 
custom column.PNG

 

After getting the custom column, then you could show % for the custom column in the Line and Stacked Column Chart. Here is the output.

 

show%.PNG

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @wingmiester,


 

In Power BI, there is no option for us to add the '%' symbol after the number directly without creating formulas. If you don't want to create the measure or calculated column,  you could create a custom column in Query Editor like below. 
custom column.PNG

 

After getting the custom column, then you could show % for the custom column in the Line and Stacked Column Chart. Here is the output.

 

show%.PNG

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for the solution, it makes sense. I ended up simplifying the SQL and just formatting it as a percentage once I had created my query,

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!