cancel
Showing results for
Did you mean:
New Member

## Showing value & text as percentage in one column

Hi all!

I am working on a set of data where the x&y values are decimals but the legend is a column with mix numbers (percentage) & text. By default, power bi sets the legend column as text, hence, the percentages are shown as decimals. However,I wanted to show the values as percentage. So, I have tried setting the column as percentage but the text part of the column becomes errors.

Is there any way to solve this? I really appreciate the help.

Regards,

Distressed

beginner

@percentage

1 ACCEPTED SOLUTION
Microsoft

Hi, @Sherlyn5

It’s my pleasure to answer for you.

According to your description, I think you can create a column to calculate the desired result.

Like this:

``````Column =
VAR legend = [legend]
VAR legend2 =
IFERROR ( ( VALUE ( legend ) * 100 ) & "%", legend )
RETURN
legend2``````

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 REPLIES 4
Super User IV

@Sherlyn5 , Can you share sample data and sample output in table format?

Proud to be a Super User!

New Member

Hi, @amitchandak , @lavdeepk thank you so much for your replies
Here is the sample data, currently i build it as a line chart (where legend, x & y are the fields respectively)

Legend           x               y

 80% 3.05286 24.4443 80% 3.51931 23.9951 80% 4.01321 23.0092 80% 4.52459 21.2729 80% 5.01563 18.9484 80% 5.50517 15.9279 80% 5.97426 12.2658 70% 2.67812 18.7314 70% 3.01138 18.4489 70% 3.51517 17.6231 70% 4.00804 16.1554 70% 4.52781 13.8832 70% 5.01735 10.8627 70% 5.21478 9.51518 90% 3.42887 30.7462 90% 3.52425 30.7419 90% 4.00954 30.1848 90% 4.53172 29.037 90% 5.03356 27.3011 90% 5.51459 24.7629 90% 6.01299 21.4207 90% 6.51931 17.3285 90% 6.70662 15.7137 100% 3.90416 38.8642 100% 4.00896 38.8059 100% 4.52287 38.2475 100% 5.02551 36.8864 100% 5.51758 35.0438 100% 6.01747 32.3977 100% 6.49701 29.1635 100% 7.02241 25.0704 105% 4.14158 42.8161 105% 4.53172 42.3703 105% 5.03505 41.3304 105% 5.51793 39.6489 105% 6.02804 37.3236 105% 6.5177 34.3566 105% 7.02505 30.7463 105% 7.44668 27.1934 60% 2.28603 13.8226 60% 2.51459 13.6517 60% 2.99954 12.934 60% 3.51172 11.5724 60% 4.00356 9.62278 60% 4.51276 6.86913 Surge 2.26683 13.7699 Surge 2.65904 18.7323 Surge 3.04332 24.4447 Surge 3.43829 30.6922 Surge 3.9422 38.8089 Surge 4.14158 42.8161 Stonewall 4.14774 8.87001 Stonewall 4.51428 10.637 Stonewall 4.78974 12.2046 Stonewall 5.16557 14.0732
Microsoft

Hi, @Sherlyn5

It’s my pleasure to answer for you.

According to your description, I think you can create a column to calculate the desired result.

Like this:

``````Column =
VAR legend = [legend]
VAR legend2 =
IFERROR ( ( VALUE ( legend ) * 100 ) & "%", legend )
RETURN
legend2``````

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helper II

I have created a calulated colunm to show value & percentage in one column i am sharing example below

``percentage & Text = FORMAT(DATA[DIFF %]*100,0)&"%"&"PTS"``

Output

When i use calulated colunm in legend this work for me you can aslo try this

Thanks

Lavdeep

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!