How to format the PBI shows apostrophe instead whole content

NeverStopLearning 0
Viewed 19

im trying to minimize the words appear in my pbi table. for eg: i have one of my columns shows

name
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

and i want to format this column to look like this

name
aaa...

i have tried reduce the size of this column but instead it shows

name
aaaa
aaaa
aaaa

once my mouse move on it it will appear the whole content how could i format this?

powerbi
1 Answers

Add this calculated column to your table:

short name = RIGHT('Table'[name], 3) & "..."

The result will look like this:

enter image description here

userhiPt0
Related