Forum Discussion

WestWinter's avatar
WestWinter
Helper II
5 years ago
Solved

How do I change format for a specific visualization?

CountryDateMetricValue
USA01/01/2021% of Males0.35
USA01/01/2021% of Males0.34
USA01/01/2021% of Males0.36
USA01/01/2021Number of Males9083297
USA01/01/2021Number of Males2307293

 

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.

Need Help
  • nvprasad's avatar
    nvprasad
    5 years ago

    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

     

     

1 Reply

  • nvprasad's avatar
    nvprasad
    Solution Sage
    5 years ago

    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