Display units - how to remove K

Hi All,

I have a table which I am rounding to the nearest thousand using Visualisations/Field Formatting/Display units and select thousands which works fine except each number in my table has a K at the end. I would like to remove the K as it is unnecessary, any suggestions. Ideally I don’t want to duplicate all my measure’s to achieve this. image

Don’t rely on the table field formatting but create a measure that divides the numbers by 1000

Hi Melissa,
It is quite annoying to duplicate all my measures. I have to duplicate around 30+ of them.

I haven’t looked into this myself but maybe Calculation Groups are worth exploring…
Here’s some information to get you started.

You could try creating a calculated column using SUBSTITUTE and then change the data type to be whole number.
Example:
Column = SUBSTITUTE( ‘Table’ [value], “K”, " " )

@KimC .You can this .


Kindly mark correct if is it solve your problem .
Thank you
or share the sample PBIX file .

@Samharisk no, that just gives me the whole number, I want it to round to the nearest thousand, I just don’t want it to display the “K”

@KimC
you can use below function .

Your Measure = ([Your Value] / 1000)

or below one

Total Step =
VAR
Result = round([TS] / 1000, 0)
RETURN

if(
Result = 0,
BLANK(),
Result
)

Thanks for your response @samharishk. I am trying to avoid the duplication of measures.
Unfortunately, it would seem I have no choice though :frowning:

If you don’t need the full detail of the original values, perhaps you could just add one new measure (say Divisor, set to 1000) and then just edit your existing measures to use DIVIDE( [your existing measure, Divisor, 0 )…

Hope this helps

Greg

Hello @KimC

Can you share you pbix file with sample data?

This would be really helpful to offer you your required solution.

Regards
Kumail Raza

Hi @KimC, we’ve noticed that no response has been received from you since the 14th of October. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!

@KimC,

While it is true that you do have to create new measures, I have a trick for you that I am using with card visuals that display aggregate measures that I have successfully tested with your situation. I usually use this technique to force a 0 to display instead of “(blank)” on cards, but it works just as well for your needs.

The important point is that you do not need to duplicate the measures, just create a new measure that divides the desired measure by 1000. This leaves with you with only one DAX statement containing your measure code so you only have to maintain the calculation in one spot. The second measure only formats the primary measure.

Here you can see the DAX I used for the formatting measure, which uses Sam’s measure branching technique. Note that I set the decimal precision to 1 even though the format is $ English which has a precision of 2 by default.
PBI_MeasureFormattingExample_DAX

And here is the primary measure and formatting measure side by side in a table.
PBI_MeasureFormattingExample_Table

I put all such measures into their own measure group to make it easy to distinguish the formatting measures from the primary measures.

Hope this helps!