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

Question

Hi&nbsp;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 the visualization .ie in bar or line chart

mariusz · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
You can create a Measure format it and use it in this specific Visual(s)
&nbsp;
Best Regards,MariuszIf this post helps, then please consider Accepting it as the solution.Please feel free to connect with me. LinkedIn 
&nbsp;

anonymous · Answer

any other solution apart from calculating new measures? because it will add a new column&nbsp; to my table&nbsp;&nbsp;&nbsp;thanks

v-gizhi-msft · Answer

Hi,&nbsp;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&nbsp;&nbsp;Best Regards,Giotto Zhi

Forum Discussion

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

3 Replies

Related content

number format help

Number Format Issue

Changing number format in a table

Dynamic number format

Organizational Apps - number format