Showing value & text as percentage in one column

[Sherlyn5]

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

[amitchandak]

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

[Sherlyn5]

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.052861	24.44432
80%	3.519306	23.99512
80%	4.013215	23.00923
80%	4.524592	21.27289
80%	5.015629	18.94843
80%	5.505171	15.92793
80%	5.974259	12.26576
70%	2.67812	18.73145
70%	3.011377	18.44885
70%	3.515169	17.62315
70%	4.008044	16.15538
70%	4.52781	13.88319
70%	5.017352	10.86268
70%	5.214778	9.515182
90%	3.428867	30.74615
90%	3.524247	30.74189
90%	4.009538	30.18476
90%	4.531717	29.03696
90%	5.033556	27.30105
90%	5.514594	24.76285
90%	6.012986	21.42066
90%	6.519306	17.32846
90%	6.706619	15.71367
100%	3.90416	38.86416
100%	4.008963	38.80594
100%	4.522868	38.24753
100%	5.025511	36.88641
100%	5.517582	35.04384
100%	6.017467	32.3977
100%	6.497012	29.16345
100%	7.022409	25.0704
105%	4.141577	42.81608
105%	4.531717	42.37029
105%	5.035049	41.33043
105%	5.517927	39.64891
105%	6.02804	37.3236
105%	6.517697	34.35664
105%	7.025052	30.74632
105%	7.446679	27.19337
60%	2.286026	13.82258
60%	2.514594	13.65174
60%	2.99954	12.93398
60%	3.511721	11.57244
60%	4.003562	9.622777
60%	4.512756	6.869132
Surge	2.266835	13.76989
Surge	2.659044	18.73231
Surge	3.043323	24.44474
Surge	3.43829	30.69218
Surge	3.942197	38.80892
Surge	4.141577	42.81608
Stonewall	4.147742	8.870013
Stonewall	4.514283	10.63703
Stonewall	4.789739	12.20461
Stonewall	5.165574	14.07319

[v-janeyg-msft · Accepted solution]

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.

[lavdeepk]

Hi @Sherlyn5 

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