Forum Discussion
Formatting column with text
Hi all,
I would like to format the whole column with added text.
For example,
The data in excel is:
| 1.80 |
| 1.80 |
| 0.10 |
And I would like it to appear as below in the table visualisation in PowerBI
| Vd=1.8% |
| Vd=1.8% |
| Vd=0.1% |
Is there any way I can custom format in Power BI like how one can do it in Excel?
Many thanks in advanced.
Hi, Anonymous
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may create a calculated column or a measure as below.
Calculated column:
Result Column = "Vd="&[Data]&"%"Measure:
Result Measure = "Vd="&SELECTEDVALUE('Table'[Data])&"%"Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous , you can create a text column with format
New column = "Vd= " , format([column],<format>)
New measure= "Vd= " , format([measure],<format>)
format refer
https://radacad.com/custom-format-fields-and-measures-in-power-bi
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
Anonymous - Yes, use the technique described in Chelsie Eiden's Duration if you want to keep them as numbers but display them the way you describe.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
If you want to not keep them as numbers, you could always do this:
New Column = "Vd=" & FORMAT([Old Column],#.#) & "%"Hi, Anonymous
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may create a calculated column or a measure as below.
Calculated column:
Result Column = "Vd="&[Data]&"%"Measure:
Result Measure = "Vd="&SELECTEDVALUE('Table'[Data])&"%"Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
