Format Field Table/Matriz

[Anonymous]

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 · Accepted solution]

@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 · Accepted solution]

@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]

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 · Accepted solution]

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

Work.

give me congratulations if you find it relevent.

[amitchandak]

@Anonymous , I am assuming this coming because of the format.

refer if this can help

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings