Forum Discussion

amalrio's avatar
amalrio
Icon for Helper V rankHelper V
5 years ago
Solved

Limit decimal on text and numeric column

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

data protection
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    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

3 Replies

  • P_D_G's avatar
    P_D_G
    Icon for Resolver III rankResolver III
    5 years ago

    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

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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