Forum Discussion

lawsc76's avatar
lawsc76
Frequent Visitor
5 years ago
Solved

Power Bi x axis date display jun and Dec

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 dis...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    lawsc76
    Frequent Visitor
    5 years ago

    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