Format columns using DAX

Question

Hello -&nbsp;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 decimal places.&nbsp;Thanks&nbsp;

erd · Answer

CMajka8&nbsp;, use FORMAT function. This article describes the cases you've mentioned:&nbsp;https://dax.guide/format/

cmajka8 · Answer

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?&nbsp;

erd · Answer

What format do you want to see?

cmajka8 · Answer

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

Forum Discussion

Format columns using DAX

4 Replies

Related content

Conditional Formatting using DAX

Conditional formating using DAX

3D Format Column Chart

Legend Format for Line Column Chart

Matrix columns formatting