Forum Discussion

CMajka8's avatar
CMajka8
Helper II
2 years ago

Format columns using DAX

Hello -  Is it possible to format the columns inside this table expression using DAX? For example, "CTR" should show as a % with 2 decimal places and "CPC" should show as a dollar am ount with 2 dec...
CMajka8's avatar
CMajka8
Helper II
2 years ago

Thank you. This is helpful. However, i think it is more complex when working with data labels. I cannot seem to get the data label to accept the format. Any suggestions?

 

  • ERD's avatar
    ERD
    Community Champion
    2 years ago

    What format do you want to see?

    • CMajka8's avatar
      CMajka8
      Helper II
      2 years ago

      For Cost metric, I would like to display as a whole number [thousands]. For example, instead of showing as $0.39M, I would like to show $390,000. And for the CTR metric, I would like to show as % with 1 decimal. Thanks