Trying to get it shown as actual percentage

[Stefan]

Hey guys,

I was doing some research and it seems like I could use the Format function to achieve my objective but when I do that apparently it returns a text and then when using the measure the visual will just appear as a blank sadly…

Is there any other way to show 0.66 in the chart as 66% instead? etc.

Thanks.

[MK3010]

Hi @Stefan

Are you selecting the “rpc_final_perc…” measure and then formatting it to % ? Is it possible for you to share a copy of pbix file?

where does it shows as text after formatting?

Check if you get similar format as shown below

[Harsh]

Hello @Stefan,

Thank You for posting your query onto the Forum.

Have you tried using the simple % format. Because if you try using the Format function the numbers will get converted into the text. And will simply either show the figures in the decimal figures or will show blank as is your case.

By the way are you trying to analyze the charts using slicer where you select Numbers and the Percentages option and accordingly the charts changes.

I’m also providing a link below where similar type of query was asked onto the forum by one of our member and how the solution was achieved.

Hoping you find this useful and meets your requirements.

If you need anything just give a shout.

Please Note: Click on the link to view the entire post and not on the expand/collapse button.

Thanks and Warm Regards,
Harsh

Switch axis between numeric and %

Hello @satichun, Still it wouldn’t be possible because when you use the "SWITCH( TRUE () )" logic the percentage number will still show it as 0.00 Format on Y-axis instead of 0.00% although you may have 2 different measures. I would like to take an example to explain it to you on the basis of screenshot provided below - [Switch Format on Y-Axis Based on Slicer Selected - 1] [Switch Format on Y-Axis Based on Slicer Selected] In the given example, I’ve two different measures one is “Total S…

Providing one more link.

Bar chart with changes between absolute number and %ages

Hello @Stuart, Thank You for posting the query onto the forum. Few days back one of our members also had the posted same type of query onto the forum. Unfortunately, as of now there’s no solution in Power BI to switch your axis or chart labels in “0.00” format and the “0.00%” format at the same time. And this is because when we apply “0.00%” format it converts the numbers into a text. I’m also providing a link of a query which was posted and the solution I’d provided to our member. Hoping y…

[Stefan]

Thanks @MK3010 ! I forgot about the format option at the top for the measure…I was trying to use the FORMAT function itself.

[Stefan]

Thanks @Harsh I guess your talking about the percent option at the top in the Modelling Section when you click on format which the other person was showing in the screenshot…Thanks for the help !