cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
matt_s
Frequent Visitor

Issues displaying Year and Months in chart

Hi,

 

I have a column called Month that is formated as Date/Time, Format: 2001-03(yyyy-MM). It looks correct in the model. I have a line chart where I would like to have both Month and Year visible, since I have data spanning more than one year. 

 

The problem is that my chart can only display Year OR Month. If I select both Year and Month in the date hierarchy, I only get Year displayed in the chart. Any ideas? 

 

Date hierarchy:

Capture1.JPG

 

Model:

Capture2.JPG

1 ACCEPTED SOLUTION
matt_s
Frequent Visitor

Ahh, obvisoluy missed that if you have a date hierarchy you have to drill down in the chart if you want to see both year and month....

View solution in original post

3 REPLIES 3
Tahreem24
Super User
Super User

Hey @matt_s ,

 

Please select your Date columna and check the name of your Date column like below screen shot.

Capture.JPG

 

Please give Thumps up for support and mark it as a solution if it helps you!

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, and Sales Analysis Report
matt_s
Frequent Visitor

I found one way to solve this by created a calculated column storing the date values as text. But I'm having a hard time understanding that this should not work with a date column?

 

Year-Month = [Month].[Year] &"-"&FORMAT([Month].[MonthNo];"00")
 
 
matt_s
Frequent Visitor

Ahh, obvisoluy missed that if you have a date hierarchy you have to drill down in the chart if you want to see both year and month....

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!