Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

How to show month and year in a chart?



I have a chart that shows accumulated values, but it only shows the year value, as the image bellow:



More than the year, I'd like to show the month as well, as this other chart:



How can I do that?



Super User
Super User

@mpoppes Well, you can create a new column that includes both month and year. Or you can put both Year and Month in the field well for the Axis and then use the forked arrow drill down.

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

When I drill down, thats what I got



I don't want to create another column so my file don't get to heavy. This other chart I've created with tha same tables, but it worked back there, and now it doesn't, I don't know why

Found out! Just right click on the date option, and changed from "hierarchy" to "date". Thanks!

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!