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

Helpful resources

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

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 109 members 1,456 guests
Please welcome our newest community members: