Forum Discussion

Anonymous

Not applicable

6 years ago

Changing number format to %,$ i.e 5%/$5

Hi can anyone help me here? how to change the formats of number data type at visualization level .ie 0.5 to 50% or $0.5 without changing the column formats from the table. I want these only during...

Community Champion

6 years ago

Hi Anonymous

You can create a Measure format it and use it in this specific Visual(s)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

Anonymous
Not applicable
6 years ago
any other solution apart from calculating new measures? because it will add a new column to my table

thanks
- v-gizhi-msft
  Community Support
  6 years ago
  Hi,
  
  I advise you to create a measure by using FORMAT function to replace the original data which will not add a new column to your visual.
  Measure is only calculated when it is used and is different from calculated columns, see this:
  https://microsoftapc-my.sharepoint.com/:u:/g/personal/v-gizhi_microsoft_com/ESSmT7lQpYVIqJssgLSZKPoB9vtYDX79MK-8pdP_dF8vlA?e=3qCAbk
  
  Best Regards,
  Giotto Zhi

Forum Discussion

Changing number format to %,$ i.e 5%/$5

Related content

number format help

Number Format Issue

Changing number format in a table

Dynamic number format

Organizational Apps - number format