Forum Discussion

trinathreddy's avatar
trinathreddy
Frequent Visitor
9 years ago

Can we have the Matrix(Preview) values formatted?

Hi,

 

Can someone tell me if we can format the values of the Matrix Preview? I  can not find the option to manage Matrix values for  thousands/Million/Billions? Also, do we have the decimal Round off option ?

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    9 years ago

    Hi there,

     

    Format of values are values are not part of any visual, it is part of modelling, select you column and then click modelling tab and change the format as required:

     

     

     

    • trinathreddy's avatar
      trinathreddy
      Frequent Visitor
      9 years ago

      Hi,

       

      Thanks for the reply. Well, I am using Live connection for SSAS. At the cube level, we need these values to be shown( Decimal upto 2

      eg:23,754.98).

      But at the matrix level data, we dont need the small value shown. so, there is no way except modifying at the cube level?

       

      Also, what if I am shoing 100,000,000 in the matrix? Dont we have have the option to change the value?

       

      Request you to pelase let me know if I can post this as an Idea? I feel, this is very basic thing. Modifying cube level data evrytime over live connection takes 2 business days  for small issues like this.