Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Community Support

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``````

If it doesn’t solve your problem, please feel free to ask me.

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

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

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
Community Support

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``````

If it doesn’t solve your problem, please feel free to ask me.

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.

Resolver I

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

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors