Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Required Month and year in x-Axix

Dear All,

 

I have result based on my input. But my client wants to have Month and year in bottom.
Being beginer I am struggling to get this.

Can any on please help me how can I get this.

1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

Syndicated - Outbound

Hi @Anonymous ,

 

Just takimh an example as follows. Create a chart with the DATE column on x-axis and your metric under values section, then you will get the following: (You will see a complete date hierarchy shown)

Pragati11_0-1624899944188.png

 

Now suppose, if you just want Month & Year on the x-axis, for that just remove the Quarter and Day part from the DATE hierarchy and then drill-down to the lowest hierarchy on the chart; you will get the following:

Pragati11_1-1624900069913.png

Thanks,

Pragati

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

1 REPLY 1
Pragati11
Super User
Super User

Syndicated - Outbound

Hi @Anonymous ,

 

Just takimh an example as follows. Create a chart with the DATE column on x-axis and your metric under values section, then you will get the following: (You will see a complete date hierarchy shown)

Pragati11_0-1624899944188.png

 

Now suppose, if you just want Month & Year on the x-axis, for that just remove the Quarter and Day part from the DATE hierarchy and then drill-down to the lowest hierarchy on the chart; you will get the following:

Pragati11_1-1624900069913.png

Thanks,

Pragati

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)