How to hide display units?

[YunJ]

Hi,

I'm wondering how to make the value not show "k", only 25,956

[v-zhenbw-msft · Accepted solution]

Hi @YunJ ,

We can use three ways to meet your requirement.

1. Create a measure to calculate the value / 1000.

value /1000 = CALCULATE(SUM('Table'[value]))/1000

2. Create a measure just show the text of K value.

value K = 
var x = FORMAT(CALCULATE(SUM('Table'[value])),"#-###")
return
LEFT(x,LEN(x)-4)

3. We can create a new table and a slicer to control the units.

Slicer measure = 
var x = SELECTEDVALUE('Table (2)'[unit])
var sum__ = CALCULATE(SUM('Table'[value]))
var y = CALCULATE(SUM('Table (2)'[Column1]),FILTER('Table (2)','Table (2)'[unit]=x))
return
IF(x="K",sum__/y,sum__)

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

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

[PKP277]

Seriously, no other display unit format solution? 

[amitchandak]

@YunJ , Have measure /1000 or use the custom format string

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

[YunJ]

Hi, @amitchandak 

There is no Property pane under View. Also, under Modeling, there is no custom option for the format.