Forum Discussion

TaroGulati's avatar
TaroGulati
Helper III
4 years ago

DAX Format Function

Hi Everyone, 

 

I have a mesaure where i am dealing with a absolute value and percentage value using switch function. 

 

for percentage i am using Format function with dot and % sign. 

 

problem is that once i am changing the language of power bi service, % decimal seprator is not changing, it is remaining as dot, instead of comma. I want it change based on the language selection of power bi service. 

 

is there any way to solve this issue?

 

thanks 

Need Help

2 Replies

    • TaroGulati's avatar
      TaroGulati
      Helper III
      4 years ago

      amitchandak i can't use measure/column tools. I have absolute and % values inside same measure. so i can't define a fix format for both from measure tools. 

       

      thanks for your suggestion.