Limit decimal on text and numeric column

[amalrio]

Hello Gurus,

I have an issue of shwoing many decimal points on my report pane, 

Below I have incuded two images

Image 1 actual data tabel

Image 2 repot page

My VALUE column contains both numaric and text values, hence I cannot control the decimal points on the repot page. I am pretty sure there should be a way to get this done. VALUE column in the tabel must cater for numaric and text type value, that is the business requirement.

Can you please assist me on this. Your help is much appriciated.

Image 1

Image 2

[v-deddai1-msft · Accepted solution]

Hi @amalrio ，

Would  you please use the following measure:

Measure = IF(ISERROR(VALUE(MAX('Table'[VALUE]))),MAX('Table'[VALUE]),FIXED(VALUE(MAX('Table'[VALUE])),4,1))

In my sample data, I have a column contains both numaric and text values and I want to control the decimal points to 4.

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

Best Regards,

Dedmon Dai

[P_D_G]

Hi @amalrio ,

Isn't using the below DAX formula an option as calculated column?

FORMAT ( VALUE ( table.name[VALUE]), "#.#####")

Where the number of "#" after the separator defines the lenght of the decimals.

Hope it helps,

PDG

[amitchandak]

@amalrio , refer if this can help

https://www.youtube.com/watch?v=YtCFAxD5qow