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

Column chart date

How do I adjust a bar chart to just show the date in month/day formatt and not Year/Quarter/Month/Day format? As seen in  the attached picture I just want my axis to say January 1 not 2016 Qtr 1 January 1.

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
shep123 Frequent Visitor
Frequent Visitor

Re: Column chart date

I just turned off the data hierarchy which solved the issue. Don't know if that will be an issue when 2017 starts but for now it works.

View solution in original post

2 REPLIES 2
Moderator v-sihou-msft
Moderator

Re: Column chart date

@shep123

 

In Power BI, the value displayed on X-Axis in a chart is based on the field value in your dataset. It's not supportd to partially hide data value.

 

In your scenario, the date column in your source table must be "Year/Quarter/Month/Day format" so that the date column can be used in Calendar hierarchy properly. If you change it into "month/day" format, this is "Day Of Year", not date level members. So don't change that into "month/day" format, otherwise you can't group those dates under Year 2016 properly.

 

Regards,

 

shep123 Frequent Visitor
Frequent Visitor

Re: Column chart date

I just turned off the data hierarchy which solved the issue. Don't know if that will be an issue when 2017 starts but for now it works.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 114 members 1,737 guests
Please welcome our newest community members: