Inserting text into an integer data label

[hashira98]

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?

[OwenAuger]

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