Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Custom Date Format

Hi,

 

I am trying to format a date column as MMM YYYY. I see that there is MMMM YYYY, but this takes up a lot of space on the x-axis of my charts. Is there a way to plug in the custom format of MMM YYYY?

 

Thanks!

 

 

Need Help

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Anonymous ,

     

    There's no such built-in format. So you may use dax function to construct such format using FORMAT(<value>, <format_string>), CONCATENATEX(<table>, <expression>, [delimiter]) and other string implementation functions.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-yuta-msft , I tried using a format function, but in doing so, it changes the column to a text format rather than date, which I don't want because then it doesn't sort properly.

      • v-yuta-msft's avatar
        v-yuta-msft
        Community Support
        7 years ago

        Anonymous ,

         

        Actually the format will be changed to text when you use format() or concatenatex(), I would suggest you to submit your idea here to help power bi add more types.

         

        Community Support Team _ Jimmy Tao

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.