How to show date hierarchy's month as a number not a name

[CloudMonkey]

Hi,

Currently my date hierarchy is showing months by their name. e.g. April is showing as "April". Please can you tell me how to make the month show by the month's number? e.g. for April to show as "4"?

Thanks for your help,

CM

[Anonymous]

hi @CloudMonkey ,

here, i am sharing my screenshots, plz check it.

This is my original Datathis is how to generated MontName and MonthNumber calculated column by using my Date columnAfter conversion my Table have All date's infoFor ex, I am using bar chart for displaying purpose my data. One thing observe here months are showing April is starting month. So next we want Jan to DecBy using MonthNumber Column we are soring monthName Column (See top of bar we have one option)Finally I Changed monthName column to MonthNumber column

[v-lili6-msft]

hi, @CloudMonkey 

You could create a custom date hierarchy then use it in the visual.

Best Regards,

Lin

[Ani1991]

Hi @CloudMonkey ,

Probably you can create a seperate mapping table like,
Month_Number        Month_name
1                                  January

2                                  February

3                                  March and so on
You can now connect this table to your fact table on Month_name column and then can pull the month number from this newly created table.

Thanks,

Anish