topic Re: Inserting text into an integer data label in DAX Commands and Tips

Inserting text into an integer data label

hashira98 — Wed, 29 Nov 2023 21:00:09 GMT

Good morning guys,

I have a need in Power BI, I have a calculated column that returns the difference between two dates, in days format. However, when I place this new field on a chart, I would like to be able to see the number of days by inserting a text description into the labels. (For example: [date] - "days") So that I can have a more descriptive analysis of the time I am viewing. Would anyone know how to help me with a solution, whether through DAX or any other type of path?

Re: Inserting text into an integer data label

OwenAuger — Wed, 29 Nov 2023 23:43:09 GMT

Hi hashira98

As a first option, I would specify a custom format string for the column, specifically this (the initial zero can be adjusted to any other format string you like):

0" days"

Does this work for you?

Regards