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.

amitchandak's avatar
amitchandak
Super User
5 years ago

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())