Forum Discussion

hashira98's avatar
hashira98
New Member
2 years ago

Inserting text into an integer data label

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?

1 Reply

  • OwenAuger's avatar
    OwenAuger
    Super User
    2 years ago

    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