Power Bi x axis date display jun and Dec

[lawsc76]

hi

I would like to show monthly data in the bar chart but x-axis only display wording Jun and Dec only.

Expected outcome.

Power BI 

After created in Power BI, notice the months displayed in chart are Jul and Jan. Is there a way to change to Jun and Dec of each year?

[v-janeyg-msft · Accepted solution]

Hi, @lawsc76 

It’s my pleasure to answer for you.

I’m sorry to say that it can’t be changed because the date displayed on the x-axis after drilling is selected by system default. You may submit an idea Here:https://ideas.powerbi.com/ideas/.

You can also set the start and end time to show the time period you want or choose ‘categorical’ type to show all time periods instead.

Like this:

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NamishB]

Hi @lawsc76 Can you share a sample data? Your expected outcome is Bar chart or line chart?

Are there multiple rows per year? you wanted to plot all data but show x-Axis with June and Dec month labels only? 

-Namish

[lawsc76]

Hi,

sorry to confuse you. It is line chart. Yes, i would like to plot all data but show x-axis with June and Dec month label only.

Have been trying few times but the label still displaying Jul and Jan.

Attached sample data for your reference. please download from link below.

https://we.tl/t-31spdE2H3E

Spoiler

[amitchandak]

@lawsc76 , Can you share sample data and sample output in table format?

Try a measure like

if(Max(date[Month])>= 6 && Max(date[Month])<=12 , [Measure] , blank())