Month number Vs Month name // Chart based on date hierarchy

[AlexDT]

Hi

In a chart with x-axis being a date hierarchy I would like to display the month number Vs the month name.

Thank you in advance

[Pragati11]

HI @AlexDT ,

I am not clear on what you mean by Month number vs month name.

Do you want both Month number and Month name on x-axis?

Do you just want Month Number in the x-axis?

Try adding some screenshot on what the requirement is.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[AlexDT]

The months are displayed as January, February, etc..

I would like 1, 2, etc..

[Pragati11]

Hi @AlexDT ,

You can do that by creating a column using DAX in Power BI.

Month Number = MONTH('Supermarket Sales'[Date])

Then move this column in place of month name on your chart. Something like below:

Let me know if this helps.

[AlexDT]

Thank you Pragati,

I wrote my issue was when displaying months on a date hierarchy.

[Pragati11]

Hi @AlexDT ,

You will need to few steps for it as shown in the video below:

What I have basically done is:

• Started with date Hierarchy in my chart.
• Removed Month and Day part of the hierarchy
• Moved Month Number to the hierarchy
• As I need Day as well, moved date hierarchy again by just keeping DAY part of it

[AlexDT]

Thank you very much.

I've tried this already but then I don't have the same display and drill drown options, such as selecting only one year by clicking the year number in the chart.

The final result should be like this but with month numbers.

Thank you again

[Pragati11]

Hi @AlexDT ,

Go to formatting options for this chart --> under x-axis --> turn off Concatenate labels

You will something like this:

You can play around with other formatting options there like gridlines.

My chart shows drill-down to DAY level.

[AlexDT]

Thank you for this,

Concatenate labels is off but this is not working, I have still the data as merged (year and month numbers)

Then by doing this I can't see anymore the empty values, even the box is ticked for each component.

 

[Pragati11]

HI @AlexDT ,

Did you switch off concatenate labels off for x-axis?

I see that working on my side.

Can you show me what you are moving to this visual?

Like I have this:

Also can you share me this setting for your chart:

[AlexDT]

Scrennshots below :

[Pragati11]

Hi @AlexDT ,

What are these fields here?

I would assume a Date Hierarchy with YEAR, Quarter, Month Number, Day.

[AlexDT]

Fiscal startdate

Année

=>are years (auto date hierarchy)

Fiscal month

=>is my calculted month number

Fiscal sartdate

Jours

=> Are adys (auto date hierarchy)

My original question is to replace month name by month number in a chart with date hierarchy and to keep all the functionalities (Drill drown, empty values and selection by clicking on years or months)

Thank you so much for your patience

[Pragati11]

Hi @AlexDT ,

Are the data-types correct for all the Year, month Number, day column calculations?

It seems to work at my end.

If possible, send me your pbix by removing any sensitive information. I can take a look then as it is hard to judge what is wrong at your end as it is working at my end.

[Pragati11]

Hi @AlexDT ,

Can you please create a new thread for this second issue please as the thread originally was getting month Number on a chart which is already resolved.

As this is taking time so better having it as a new thread and accepting solution to the original thread's answer.