changing Month name to number in Table visual

[lastnn30]

Hi

I have a table which has Date column and it is formatted as DD-MM-YYYY. In Power BI -->Report, when I use Table visual and move Date column inside I see Date hierarchy and I can remove year, day, quater and keep only month. But the month is showing as March. How can I change March to 3 instead? Thank you very much.

 

[FreemanZ]

hi @lastnn30 

try to plot with a calculated column like:

Month = MONTH([Date])

[andhiii079845]

You use the auto time intelligence function? I think you have to create a own dimtable for the date and create your desired columns like number of month there, create a relationship to your fact table and use than the columns from the date dimension in your visual.