cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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.

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,

 

Highlighted
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.

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 247 members 2,597 guests
Please welcome our newest community members: