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
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!