How to resolve this..............

Hi Pratima,

From your description, it seems you want to display the date type column in the format of month name plus day, right?

It depends on which kind of visual you used to represent data. There are three ways:

1. We can set the data format for the date type column below:

2. If you use charts, like line chart, column chart, you can keep the Continues type enabled for X-axis to get expected format.

In charts you can also enable Date Hierarchy, and keep Concatenate Labels enabled.

3. Create a calculated column to return values in the format of month name plus day like below:

Column = FORMAT(MONTH('Table2'[Date]),"MMM") & " " & DAY('Table2'[Date])

Best Regards,
Qiuyun Yu

Thanks Qiuyun Yu ,i got the expected result.....................by using the following function:

Column = FORMAT(MONTH('Table2'[Date]),"MMM") & " " & DAY('Table2'[Date])