Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Problem with Stacked Column Chart and years

Hi guys,

 

Would like to seek your help on this problem. I have a clustered column chart with years on the X axis and another line chart with time on the x axis. When I press to highlight one of the years the line chart only shows half of the years (March to November) and not the entire year. Not sure where the problem is coming from, would appreciate any help at all.

 

Thanks!

 

 

 

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Anonymous ,

     

    If so,you have to create 2 columns for year and month:

    Year = YEAR('Table'[Date])
    Month = FORMAT('Table'[Date],"MMM")

    Then put the 2 columns together as X axis:

    And you will see:(now the X axis is showing continuous)

     

     

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

     

     

     

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , is a line visual showing a point or line. If line it means it is showing two points for each one for one half year

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Ah I get it now, is there anyway to only change the X-axis labels when I press into the years? I think it will be very confusing to readers due to the scale and the labelling.

       

       

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        5 years ago

        Hi Anonymous ，

         

        Select the line chart,go to format>under X axis,change "Type" to "Categorical":

        And you will see the full months showing:

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my post as a solution!