cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lorddog Regular Visitor
Regular Visitor

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

Accepted Solutions
lorddog Regular Visitor
Regular Visitor

Re: axis date not showing month + year

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 New Contributor
New Contributor

Re: axis date not showing month + year

Drill down a level in the hierarchy?

lorddog Regular Visitor
Regular Visitor

Re: axis date not showing month + year

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

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 52 members 968 guests
Please welcome our newest community members: