Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

axis date not showing month + year

i have 2 charts and the first one works fine without any changes to axis hierarcy. by default it puts "may 2019" ect for each month + year.
my 2nd chart i did reimport data where the date field might have thought it was different. i don't know.
anyhow my 2nd chart when i drop the date onto the axis it asks for a choice of (year, quarter, month, day)
if i choose (year + month) it only shows year and groups values to the year. 

if i choose (month) it only shows months and groups previous years into it.

how do i get my 2nd chart to view the date column on the axis as month + year?

i do see i can go to table view and modeling and change the date type and format to same as my first chart, but that doesn't fix it.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

ah i found it.
axis > date column > click down arrow and select the column name instead of the Date Hierarchy 

View solution in original post

2 REPLIES 2
jthomson
Solution Sage
Solution Sage

Drill down a level in the hierarchy?

Anonymous
Not applicable

ah i found it.
axis > date column > click down arrow and select the column name instead of the Date Hierarchy 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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