Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Format String Expression to reflect absolute and percentage value

Hello, I need to reflect value on a column chart in both absolute and percentage (in relate to other number) value. Example below.     In order to do so, I used format string expression in ...
Need Help
vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
4 years ago

Hi, Anonymous 
Try something like this:

Formatting = 
var wyk = FORMAT ( MAX(SomethingSomething[Something]), "#,###,###.00")
var wyk_p = FORMAT ( MAX(SomethingSomething[Something2]), "##.00%")
return wyk & " / "& wyk_p

 

SergioSilvaPT's avatar
SergioSilvaPT
Icon for Resolver V rankResolver V
4 years ago

vojtechsima why you used the MAX function inside the FORMAT?

  • vojtechsima's avatar
    vojtechsima
    Icon for Super User rankSuper User
    4 years ago

    Hi, SergioSilvaPT 
    Just to make my sample data work, it is not necessary, but I didn't have row context so I had to help myself with MAX.

    • SergioSilvaPT's avatar
      SergioSilvaPT
      Icon for Resolver V rankResolver V
      4 years ago

      OK, thanks for the explanation!

       

      That's the beauty of Power BI and Data Analysis, you don't have one unique solution, you have many that can be used to achieve our requirements! 😊