Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Format Field Table/Matriz

I have the following matrix and I wonder if it is possible to hide the unit (mill) but still get the same number. All columns are measures. I know that I could just divide by 1000,0000 on each measure but since I have more visuals and different grouping by sometimes I use thousands as unit and I dont want avoid duplicating measures and create a whole pack for millions and another for thousands. .

 

  • Anonymous's avatar
    Anonymous
    5 years ago

    Anonymous  You Need to Change the formatting in Data model view . Just Click onn visual and in properties pane  Select custom or WHole number in formatting and change the value  give it  number (if custom formatting selected ).

    Please find the image for your help .

     

     

     

  • Anonymous's avatar
    Anonymous
    5 years ago

    I showed you that to measure only .just click on the measurement and update it.

    Work.

    give me congratulations if you find it relevent.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous  You Need to Change the formatting in Data model view . Just Click onn visual and in properties pane  Select custom or WHole number in formatting and change the value  give it  number (if custom formatting selected ).

    Please find the image for your help .

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      HI I can not do that since the columns I showed were measures. I thought that there were a way to do it through the table

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        I showed you that to measure only .just click on the measurement and update it.

        Work.

        give me congratulations if you find it relevent.