How do I change format for a specific visualization?

[WestWinter]

Country	Date	Metric	Value
USA	01/01/2021	% of Males	0.35
USA	01/01/2021	% of Males	0.34
USA	01/01/2021	% of Males	0.36
USA	01/01/2021	Number of Males	9083297
USA	01/01/2021	Number of Males	2307293

Hi all, I would like to set specific formats for specific visualizations. As you can see above, my table has 2 metrics - % of males & no of males and the default format is in Percentage... Am seeking advice on how should I modify the format for a specific visualization? As for Number of Males Visualizatation, it multiples the number by 100 and shows the number as a % which is not what I want...

However, I would still like to keep the general % formatting for the field as well.

[nvprasad · Accepted solution]

Hi WestWinter,

You can modify the format of the measure by using the FORMAT function in DAX. 

You can multiply the number by 100 then concatenate "No of Males".

https://docs.microsoft.com/en-us/dax/format-function-dax

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad