topic Re: Format columns using DAX in DAX Commands and Tips

Format columns using DAX

CMajka8 — Tue, 05 Sep 2023 15:05:51 GMT

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 decimal places.

Thanks

Re: Format columns using DAX

ERD — Tue, 05 Sep 2023 17:50:11 GMT

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

Re: Format columns using DAX

CMajka8 — Wed, 06 Sep 2023 00:31:00 GMT

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?

Re: Format columns using DAX

ERD — Wed, 06 Sep 2023 06:15:00 GMT

What format do you want to see?

Re: Format columns using DAX

CMajka8 — Wed, 06 Sep 2023 13:14:04 GMT

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